Auto Status Change/Update

edited 12/09/19 in Formulas and Functions


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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!