How so I get a report to sort in order of date?

This may just be a vent, but I have a report that pulls from about 15 different sheets with archived data from 2024 and 2023. I want the most recent submissions to show first. When I sort the report by the Date/Time column by descending order, it doesn't work. It'll start with 1/1/24 first and work through today (3/22/24). Then it will start with 1/1/23 and work through 12/31/23.

Why does it do this? How do I get the report to show today's date first and descend from there?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!