Evaluation of date-related formulas used in workflow conditions



We have to implement a date/time triggered workflow that will run every day. In it, there is a condition which uses a value of the checkbox-type cell with the formula that turns the checkbox ON, when a certain number of days have passed (since some event).

The question is - will that formula be evaluated and so be correctly setting up the checkbox value before the workflow condition is evaluated? Or - is opening of the sheet by a user required to evaluate the formula (before the timed run of the workflow)?



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!