function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Lisa Lee-BanksLisa Lee-Banks 

Is it possible to pass the value of a text field rather then a literal string when using IF(ISPICKVAL(Inset Field, "Picklist Value"), "Value of text field")

I would like to pass the value of a text field 'Down Payment Other Description' to a formula field when the value of the picklist field 'Down Payment Other' = Required.

This formula field syntax passes the literal text string 'Down_Payment_Other_Description__c' to the formula field.

IF(ISPICKVAL( Down_Payment_Other__c ,"Required")," Down_Payment_Other_Description__c ",null)
Best Answer chosen by Lisa Lee-Banks
David Zhu 🔥David Zhu 🔥
You may need to remove the quotation mark for that field and please make sure the formula field has the same field type as Down_Payment_Other_Description__c

IF(ISPICKVAL( Down_Payment_Other__c ,"Required"),Down_Payment_Other_Description__c,null)

All Answers

David Zhu 🔥David Zhu 🔥
You may need to remove the quotation mark for that field and please make sure the formula field has the same field type as Down_Payment_Other_Description__c

IF(ISPICKVAL( Down_Payment_Other__c ,"Required"),Down_Payment_Other_Description__c,null)
This was selected as the best answer
Lisa Lee-BanksLisa Lee-Banks
Thanks David - that was the solution.