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?


  • Bassam Khalil
    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.

    PMP Certified

    ☑️ 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!