Formula to change task status to "At Risk" If due date is within 1 week



I am wondering if you can help me create a formula that will change the site status to "At Risk" if the due date is within 1 week and the status is not complete or not applicable.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!