How to assign static Due Date based on IF function


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!