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

Amanda G Lima

Hello!

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!

Calendar App Settings.png

Uploaded May 13, 202253.27 KB

Calendar App View.png

Uploaded May 13, 202257.38 KB

Smartsheet Columns.png

Uploaded May 13, 202227.77 KB

Genevieve P.

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:

09:57

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

Cheers,

Genevieve

Genevieve P.

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:

09:57

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

Cheers,

Genevieve

Amanda G Lima

You are so good! This worked. Thank you.

Genevieve P.

Wonderful! I'm glad I could help. 🙂