Can you make a sheet auto sort dates, if the date changes?
Answers
-
Hi @Dakota
Sorting in Sheets is a manual application. This means you would need to re-sort the sheet after updates have been made, see: Sort Rows to Organize Your Data
However if you create a Row Report from your sheet, you can apply a sort to the Report which will automatically update any time you look at the Report. See: Sort Your Report Results with Report Builder
Cheers,
Genevieve
Need more information? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao!👋 | Global Discussions
-
Hi @Dakota, I built a browser extension (SSFeatures) that lets you auto sort.
SSFeatures adds this "Sort Automatically" button that you can use to enable automatic sorting whenever your data changes.
Best!
Nathan Braun (Founder of SSFeatures) (nathan@ssfeatures.com) (LinkedIn)
SSFeatures makes Smartsheet way easier to use and it saves you hours of work every week. It adds essential features into Smartsheet to save you time. For example: — Auto Sorting — Sorting with Filters — Report PDF Generation — Copy and Paste Conditional Formats — Copy and Paste Automation Workflows — Column Manager — and so many more.