You need to sign in to do that
Don't have an account?
honda57
formula using picklist & text fields together
I'm driving myself crazy with this. It's a simple logical formula but I can't get it right in salesforce.
If(SC_Coverage_Type__c,"Service Contract" & IF(Expiration_date,">180"),"SC Expired >180 days", "Active")
I know this isn't how you do it in salesforce, but it's the logic I'm trying to implement.
SC_Coverage_Type__c is a Picklist field
Expiration date is a text field.
Please help
So your formula needs to look something like:
IF(ISPICKVAL (SC_Coverage_Type__c, "Service Contract") & Expiration_date > 180), "SC Expired > 180 days", "Active").
Hope this helps.
Thanks!
This formula (including the use of two && symbols) did the trick.
Appreciate the help!
Thanks Jakester for catching the ampersand issue.