IF (Year_Lead_Created__c=2017,
CASE ( MONTH (Create_date_no_time__c) ,
1, "January 2017",
2, "February 2017",
3, "March 2017",
4, "April 2017",
5, "May 2017",
6, "June 2017",
7, "July 2017",
8, "August 2017",
9, "September 2017",
10, "October 2017",
11, "November 2017",
"December 2017" ),
null)
I would like to add the following to it:
IF Lead Status (picklist value) equals "Dead" then the Marekting Plan Name would be "DEAD".
I've tried multiple if/and/and ispickvals - and am not getting it right. Can a formula Guru please help me with the above?
8 respostas
Try this IF(TEXT(Status) = "Dead","DEAD",
IF (Year_Lead_Created__c = 2017,
CASE ( MONTH (Create_date_no_time__c) ,
1, "January 2017",
2, "February 2017",
3, "March 2017",
4, "April 2017",
5, "May 2017",
6, "June 2017",
7, "July 2017",
8, "August 2017",
9, "September 2017",
10, "October 2017",
11, "November 2017",
"December 2017" ),
NULL)
)