Formula & Placement for Automating Status based on End Date

Rebecca BdR

Hello Smartsheeters! I would so appreciate your help with this - I'm watching all the videos/reading the help articles, but I'm still not getting it!

Goal: Automate Status column updating

When the Status of a task is not changed to 'Complete' one day after the row's 'End/Due Date,' I want the Status to change to 'At Risk.' I believe this would be a column formula, but that option is grayed out for me. Also, where would I place the formula - in the 'Status' or 'End/Due Date' columns?

Here is the formula I have - if it's wrong, please advise!

=IF(AND([Status]@row <> "Complete", TODAY() > [Due/End Date]@row + 1), "At Risk", [Status]@row)

Thank you in advance!

ECarlson_PCG

Hi Rebecca!

I think this was just double posted.
Answered on the other thread:

https://community.smartsheet.com/discussion/138307/formula-placement-for-automating-status-based-on-end-date

Rebecca BdR

It was! I couldn't tell if it had posted or not, and then I don't see a way to delete the duplicate. 😄