0

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?

1 Answer 1

1

Use the CASE function.

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

2
  • Although 1 month can be anywhere from 28 to 31 days...
    – Adrian Larson
    Aug 25, 2016 at 22:45
  • @AdrianLarson this is acceptable for the most cases, otherwise he would have to deal with a complex formula like search for 'Adding Days, Months, and Years to a Date' here
    – o-lexi
    Aug 25, 2016 at 23:59

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .