Can I add time windows to reports when scheduling with Smartsheet
I'm using Smartsheet to schedule my service department. I'm able to sort by date but there are occasions where I have multiple calls for one individual in a single day. I'm trying set it up where the calls will be sorted by time windows so that I don't have to rely on my guys reading the notes, which they rarely do. Is this possible? Any ideas?
Answers
-
Hi @Roger Henneke
Hope you are fine, you can add the system column "Created" then collect the time for each row to a helper column call "calls Time" it by using the following formula and convert it to column formula:
calls Time =MID(Created@row, 12, 8)
then you can use this helper column to sort your calls.
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
Check out the Formula Handbook template!