Can I add time windows to reports when scheduling with Smartsheet

Roger Henneke

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?

Bassam Khalil

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.