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
Check out the Formula Handbook template!