Auto Status Change/Update
Hi,
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?
Tags:
0
Comments
Give this a try...
=IF(TODAY() - [Due Date Column Name]@row > 0, "Delayed")
thinkspi.com
hi,
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?
thinkspi.com
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.
thinkspi.com
These are my columns:
Task name
Duration
Start (dates)
finish (dates)
Predecessors
Status (red,green,yellow symbols
completed (checkbox)
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")
thinkspi.com