Hi All,
I need quick advice on this following item. I need to calculate new formula field which will add 1 month, 3 months, 6 months, 1 year and none from the existing due date field when picklist field is selected as below:
Formula example :
If Picklist value is selected 'Annually' then formula would be (Due_Date__c + 1 Year)Annually : Due_Date__c + 1 YearHalf-yearly : Due_Date__c + 6 MonthsQuarterly : Due_Date__ct + 3 MonthsMonthly : Due_Date__c + 1 MonthNone : BlankLooking forward for the quick help and thanks in advance..!!5 respuestas
Hey,
Thanks for your replies. Really appreciate it. I tried with below formula and it worked. Similar as yours but used CASE function instead of multiple if's.
CASE(GAM_RecurrenceFrequency__c,
"Monthly", ADDMONTHS(RocketDocs__Due_Date__c,1) ,"Quarterly", ADDMONTHS(RocketDocs__Due_Date__c,3),"Half Yearly", ADDMONTHS(RocketDocs__Due_Date__c,6),"Annually", ADDMONTHS(RocketDocs__Due_Date__c,12), null)
