automations by hour
I am trying to setup an automation to let me know when something has been entered into a smartsheet for more than a set amount of hours. Ie. if someone entered a new line 1 hr ago it lets me know when an hr is up. Looks like everything is only setup in days but would like to breakdown further into hours and not sure how to do it. Using SS in a ticketing system and want to have some deadlines for 1 hr, 6 hr and 24 hrs past when someone has submitted a ticket. I have a column documenting when a ticket is submitted and it tracks the time/date so wanted to setup a reminder on the hour instead of just days.