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 )