Auto Status Change/Update
I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 and the status box of completion is not checked yet, is there a way to create something that will automatically say delayed or something of that sort until the box is checked?
Give this a try...
=IF(TODAY() - [Due Date Column Name]@row > 0, "Delayed")
It did not seem to work on my end! but thank you!!
I missed the Complete portion in the first formula.
=IF(AND([Complete Column Name]@row = 0, TODAY() - [Due Date Column Name]@row > 0), "Delayed")
What didn't work for you? Did you get an error message, or was it that I had forgotten to include the AND part?
It gives me the error message of invalid operation or unparseable.
How are your columns formatted, and what are the names of them? I may be able to give you something more specific to your need as opposed to a semi-generic formula as above.
These are my columns:
Status (red,green,yellow symbols
I don't see a "Due Date" column. Without that you would need something along the lines of
=IF(AND([email protected] = 0, TODAY() - ([email protected] + [email protected]) > 0), "Delayed")
Help Article Resources
Check out the Formula Handbook template!