Is there a way automatically order based on date? (Automatically sorting by date in descending order

Christian Ong

Hello,

I was wondering if there was a formatting of some sort that would automatically sort my sheet based on "Effective Date" in descending order.

For my sheet, data would be inputted via forms and would be asked for "Effective Date." When the data goes into the sheet from the form, is there a way to automatically sort it based on "Effective Date?"

Thank you for your help!

Katie G

I think the best option is to create a Report that creates a view of the Sheet sorted the way you would like

Mike TV

@Christian Ong

On your sheet you can right-click a date column and choose Sort. It will sort it by date either ascending or descending as you choose. However, it's not automatic. It will only sort what is currently on the sheet so as things are added to the sheet they might get out of that sort order.

If you need something automatic, I would suggest creating a report from the sheet. From the report you can choose a sort option that will stay in place no matter new rows being added.

SSFeatures

Hi @Christian Ong,

I created a browser extension that adds automatic sorting into SmartSheet, and it works even when new values arrive from a Form. You can can click here to download the browser extension.

Then click "Sort Rows":

Then click "Sort Automatically":

Then the browser extension will automatically sort whenever the data changes, or when new values arrive from a Form. The browser extension also saves your sort settings, so that you don't need to manually re-enter them.

Also, this automatic sorting works with filters. So if you enable automatic sorting, and then add a filter, the extension will automatically sort the data even with a filter enabled.

I hope this works for you!