Auto Status Change/Update

rochen
rochen ✭✭
edited 12/09/19 in Formulas and Functions

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!