I have a Picklist field (Field Name: Billing Text) with the following values (Specific Date, 1, 2, 3)
I need to write a formula that states the following scenerio and writes a certain text:
- If Picklist Field = "Specific Date" - enter this text: "All fees as indicated below begin on the Effective Date"
- If Picklist Field DOES NOT EQUAL "Specific Date" - enter this text: "All fees as indicated below begin (Billing_Begins_Months__c) after the Effective Date."
Can anyone assist?
What datatype is the Billing_Begins_Months__c field?
If it's a Number or Picklist you could use
CASE( Billing_Text__c,
'Specific Date',
'All fees as indicated below begin on the Effective Date',
'All fees as indicated below begin ' +
TEXT(Billing_Begins_Months__c) +
' after the Effective Date.')
or if it's Text
CASE( Billing_Text__c,
'Specific Date',
'All fees as indicated below begin on the Effective Date',
'All fees as indicated below begin ' +
Billing_Begins_Months__c +
' after the Effective Date.')
