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?
Β
Comments
-
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?
-
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:
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(completed@row = 0, TODAY() - (Start@row + Duration@row) > 0), "Delayed")
Help Article Resources
Categories
Check out the Formula Handbook template!