Alert After a Certain Time



I am trying to set up an alert to notify someone when a new row is added between 3PM and 5AM. This will cover proper alerts get sent out during non working hours.

The submissions will be inputted by customers via a form. I need the alerts to get to the correct people after hours.

I was trying use the created date and time column but can not think of how to use that time stamp or and formula to extract that info.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!