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
Nathan NipperNathan Nipper 

Populate currency formula field with formula field total if picklist is approved

I have a picklist field 'Status' with three options. Requested, Approved, and Denied. I have a currency field 'Total Price' with a requested total. Lastly, I have a currency formula field 'Accepted Total' that I only want to populate with the same amount from the 'Total Price' field if a picklist selection is Approved. Otherwise the Accepted Total is just blank. What's the best way to do this?
Best Answer chosen by Nathan Nipper
Maharajan CMaharajan C
Hi Nathan,

Please use the below formula in Accepted Total currency formula field :   
IF( ISPICKVAL(Status, 'Approved'), Total_Price__c, Null)

And  chose the Treat blank fields as blanks in Blank Field Handling section . Refer the below screenshot for this.
https://success.salesforce.com/servlet/rtaImage?eid=90730000000DMV6&feoid=Body&refid=0EM300000004p5M

Thanks,
Maharajan.C

All Answers

Maharajan CMaharajan C
Hi Nathan,

Please use the below formula in Accepted Total currency formula field :   
IF( ISPICKVAL(Status, 'Approved'), Total_Price__c, Null)

And  chose the Treat blank fields as blanks in Blank Field Handling section . Refer the below screenshot for this.
https://success.salesforce.com/servlet/rtaImage?eid=90730000000DMV6&feoid=Body&refid=0EM300000004p5M

Thanks,
Maharajan.C
This was selected as the best answer
Nathan NipperNathan Nipper
Wow I was making it way too complicated. Thank you, worked perfectly!