[SalesForce] Process builder add a specific amount of weeks or months to a date

I have a picklist field on Opportunity called Delivery_Followup__c with the values: 2 Weeks, 3 Weeks, 1 Month.

I have a process builder that creates a task to followup with the customer and we want to set the due date to be Today() + Delivery_Followup__c.

Is there a way to add the weeks/month to the Today() function in a process builder formula?

Best Answer

Use the CASE function.

TODAY() + CASE ( Delivery_Followup__c, "2 Weeks", 14 , "3 Weeks", 21 , "1 Month", 30 , 0 )

Related Topic