Automatically Check a Box upon entering a date and time

edited 05/04/23 in Formulas and Functions


In my Smartsheet sheet, I'd like to set up a system to check off meetings automatically. I'd like to enter a date (ex: 04/15/23) in a column and the time span in another column (ex: 12:30 - 2:30 PM). It would then automatically check a box in next column if the start time have already passed.

Any advice would be deeply appreciated.

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!