How to assign static Due Date based on IF function

Options

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)..................

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!