Skip to main content
Lynn Shield (MeetSoci) 님이 #Sales And Marketing에 질문했습니다
I have the following formula that is working great on my LEAD Marketing Plan Name custom Field:

 

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개
  1. 2017년 8월 17일 오후 7:58
    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)

    )