Calendar App - Won't Sort by Time in 24hr Format Chronologically
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!