How do I automate At Risk flag to change to red 72 hours prior to deadline/task end date?


Hi - I'm trying to automate the At Risk flag to change to RED 72 hours prior to the task deadline so it can trigger an email to the person assigned to the task. I have created the workflow/alert email upon red flag trigger, so that part is done, but I have not found the right formula to change the At Risk flag automatically vs. manually. I have tried a few different returns, but the only one that works so far is 1, 0, whereby 1 means the task is within the 72 hour trigger window and not marked as Complete (status) and 100% Complete (% Complete). Here's what I have - seeking a solution. Much appreciated!!

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!