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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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!!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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. 

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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) 

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    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