Hey community, I need to create a formula field to show text based on the value in a picklist.
One of the formula values also needs to include a date from another field.
It will then be used to continue this sentence: "This change is (formula field)."
This is what I have so far - can someone please tell me where I've gone wrong? Thanks in advance!!
IF(ISPICKVAL(This_change_is__c, "Permanent"), "permanent"),
IF(ISPICKVAL(This_change_is__c, "Temporary"), "temporary and ends on"&"DATE(E_Contract_End_Date__c)"),
""))
8 answers
Hi Robert ,
Try this
IF(ISPICKVAL(This_change_is__c, "Permanent"), "permanent",
IF(ISPICKVAL(This_change_is__c, "Temporary"), "temporary and ends on"&"DATE(E_Contract_End_Date__c)") ,
NULL)
)
