How to assign static Due Date based on IF function

otavilog

From the table example below. When a specific value is chosen from the "Progress" dropdown column I want Due Date to have a static date assigned.

Currently I have the following but every day the Due Date is updated due to TODAY function I used. Any recommendations?

IF(Progress@row = "Waiting on Sales", TODAY(5), IF(Progress@row = "Waiting on Pricing", TODAY(5)..................

JamesB

@otavilog

I use a workflow to set a date on the row when a specific cell in that row changes. This will keep the date static until the status changes on the cell in that row again. You will need a helper column to use the plus 5 function.

Example:

Static Date - Use automation to set this date.

Due Date =[Static Date]@row+5

otavilog

@JamesB got it to work. Thank you so much.

JamesB

Your Welcome.