Setting automations based on time in a cell


Automations can be set to run on a date found in a cell. Automations are able to be set to run at a particular time.

Is there a way to have the automation look at the time in a cell just like with dates?

This is so important as certain alerts are not only date sensitive but also time-sensitive.

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    @Genevieve P.'s suggestion is what I usually do. I create a helper column with a formula to output 00, 01, 02, 03, so on and so forth all the way up to 23 (making sure they are all "text" for consistent formatting) then create 24 workflows. The one for 12am has a condition of the helper column being 00. 1am's condition is 01, and on we go. It sounds like a lot, but you can create the first workflow from scratch then duplicate it, adjust the title, trigger time, and condition, save, duplicate, ............ It is a bit tedious but doesn't take too long once you get on a roll with duplicating and tweaking.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!