Calendar App - Won't Sort by Time in 24hr Format Chronologically

Amanda G Lima
Amanda G Lima ✭✭✭✭
edited 06/14/22 in Add Ons and Integrations


I'm using smartsheet for a social media post calendar. It includes the date to be published in one column and the time to be published in another. The time column is 24hr format so that we can have it display in chronological order. However, that is not happening in the premium Calendar App view.

Am I missing something? When I sort the source data by the Publishing Time column it is accurate - it just won't do it on the Calendar App. I've tried the Calendar App setting as ascending and descending. I have no other Calendar App sorting applied.

See screenshots attached of the source data, the Calendar App view, and Calendar App settings. Thank you!

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    Hi @Amanda G Lima

    The Calendar App is reading "9" as coming after the "1" in 12. Try adding a 0 in front of your morning hours, like so:


    This way the 0 will come before the 1 in 12, 13, etc. Let me know if this works for you!