0

An odd request, I know.

What I'm looking for is a formula on the Account object that grabs the most recent Contact name that is assigned to an opportunity / quote.

Is this possible with a formula or should I be creating a flow to accomplish this?

2
  • 3
    Possible via a roll-up rather than a formula. Unfortunately out of the box roll-ups won't do this. Look at Roll-Up Helper or DLRS and upvote this idea
    – identigral
    Apr 12, 2022 at 19:02
  • 3
    ...another, perhaps easier option is a dynamic, admin-filtered related list available in Summer 22: ideas.salesforce.com/s/idea/a0B8W00000GdimuUAB/… . Whether it will go down to the level of filtering that you need is a question mark but worth looking at.
    – identigral
    Apr 12, 2022 at 19:14

1 Answer 1

0

It's not possible to use a formula by itself to do this because there is a many-to-one relationship between Opportunities and Accounts and similarly, complex relationships between Contacts and Quotes. Formulas are not able to reference multiple children or multiple records that look up to the record with the formula on it.

You will need to use a flow or an Apex trigger to grab this data when the associated record is updated.

Standard Sales Cloud Objects data model. Many-to-one relationship between Opportunity and Account. Many-to-one relationship between Contact and Account. Many-to-many from Quote to Opportunity & Quote to Contact.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .