You need to sign in to do that
Don't have an account?
Nathan 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?
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
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