function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Show Opportunity Stage on Account



I need to show the stage of the best opportunity on the related account.

I have done a similar thing with Expected Sign date like bellow.

Expected Sign date

Expected_Sign_date__cRoll-Up Summary (MIN Opportunity)

However a rollup summary is not available for the Stage variable. I recon because it is a list.


Do you have any ideas on how to get the opportunity stage with the highest opportunity probability to the account?


One way that you could achieve this is to hold a lookup to the highest probability opportunity on the account record.  You can then use formula fields to retrieve the various fields.


You'll need a trigger for every insert/update of an opportunity so that you can compare it against the highest probability stored for the account and overwrite if necessary.  You'd also need one for deletes so that if the highest probability is deleted you find the next in line and apply that to the account.