Trigger workflow based on time of day a request is received
Hello Community! I have a question I wanted to bring to the table...
I've been working on some processes and workflows for triaging work on my team. Requests come in through an intake form and we have automations to assign to specific resources based on the type of project/request that it is.
Now, we are trying to make Smartsheet assign the same type of project/request to different people based on the time of the day that the request (form submission) is received. For example: if request is received between 12:00 AM EST and 12:00 PM EST assign to Robert / if received between 12:01 PM EST and 11:59 PM EST assign to Carol.
Have you ever tried implementing something like this? I know there's not a straight forward functionality to set up this but maybe someone has a workaround?
Help Article Resources
Check out the Formula Handbook template!