Skip to main content
Topics#Data ManagementAngelica Manag の質問
Angelica Manag (Fluidigm Corporation) が「#Data Management」で質問
2019年9月6日 23:16

How do I edit this formula to return a blank field if these fields referenced are blank? Current Formula: Service_Plan_Start_Date_Text__c + "-" + Service_Plan_End_Date_Text__c TIA!

4 件の回答
  1. Priyankaa Dadhe
    2019年9月9日 17:00
    Hi Angelica,

     

    Give it a try : 

     

    CASE(

     

    MONTH(SBQQ__QuoteLine__r.SBQQ__EndDate__c),

     

    1, "Jan",

     

    2, "Feb",

     

    3, "Mar",

     

    4, "Apr",

     

    5, "May",

     

    6, "Jun",

     

    7, "Jul",

     

    8, "Aug",

     

    9, "Sep",

     

    10, "Oct",

     

    11, "Nov",

     

    12, "Dec",

     

    " ")

     

    Regards,

     

    Priyanka
回答を記入...
0/9000