IS there a way to sort/filter rows from Newest to Oldest?

Syllica

Hello everyone,

I am trying to create a filter where it puts the rows from Newest to Oldest. For some context, we use this Smartsheet log to capture customer requests and this log has requests from 2022 (being at the top) until now (we're in 2024, being at the bottom). We're always having to scroll all the way down to the sheet and it has over 1900+ rows now. It would be nice to avoid this if there is a capability to do so.

Let me know if you need me to include the columns in the Smartsheet for a function or code. But, I am just looking for a way to sort from newest to oldest request. Newest being at the top rather than the bottom. I tried myself but I couldn't find a way. Also, SS has the "sort rows" option grayed out.

Is this possible?

Thank you in advance.

Lucas Rayala

Hi @Syllica -- that's actually an enhancement that's on the roadmap. I have some custom code to do this via the API, but you can't do this with native tools yet.

Lucas Rayala

Hi @Syllica -- that's actually an enhancement that's on the roadmap. I have some custom code to do this via the API, but you can't do this with native tools yet.

Syllica

https://community.smartsheet.com/discussion/comment/413373#Comment_413373

Thank you Lucas for your quick reply. Good to hear this is being considered in the future. It'll be helpful.