Using the timestamp (from system create date column) to automate task assignment

Hello -

I've been trying to test an automation workflow rule to assign tasks based on the timestamp of the request that is received but i'm stuck and could really use some advise on how to make this work.

I have a date create column and i am using this substitute & dateonly formula to extract the timestamp (being stored in a new column). I then created an automated task assignment rule, with three conditional paths -

1) If timestamp is in between 11 PM - 8 AM - assign to A

2) If timestamp is in between 8:01 AM - 3PM - assign to B

3) otherwise assign to C

Can someone advise on how i can achieve this? Many thanks!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!