Is it possible to get rows automatically sorted in a sheet as new rows are added?
I have several sheets where it would be incredibly useful for them to automatically sort as new rows get added & cells change. Is there a workflow I can set up to do this so it automatically sorts on some kind of timeline (daily, weekly, etc.)?
Answers
-
We do this via the API. We have a cron job that runs on a remote server that issues this command every hour
curl --silent "https://api.smartsheet.com/2.0/sheets/$Sheet_ID/sort" -H "Authorization: Bearer $token" -H "Content-Type: application/json" -X POST -d '{"sortCriteria": [{"columnId": $Column_ID, "direction": "ASCENDING"}]}'
/marc
-
Hi @ro.fei, I created a browser extension (SSFeatures) to make this possible. With this extension, click this "Sort Automatically" button and then your data will sort whenever it changes.
Hope this helps!
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.
