I created a formula date field and I added the formula below , however I received the error message " Error: Incorrect number of parameters for function 'IF()'. Expected 3, received 2 "
IF(State__c = "Texas", Date_Test__c + 365, NULL,
IF(State__c = "Georgia", Date_Test__c + 500,NULL,
IF(State__c = "Texas", Date_Test__c + 1200
)))
I could need some help on this formula
FYI - State__c field is a formula(Text) field and Date_Test is a date field.
8 answers
Try this
Date_Test__c +
CASE(State__c,
"Texas", 365,
"Georgia", 500,
"Texas", 1200,
0)
orDate_Test__c +
CASE(State__c,
"Texas", 365,
"Georgia", 500,
"Texas", 1200,
NULL)
