Is it possible to get rows automatically sorted in a sheet as new rows are added?
![ro.fei](https://us.v-cdn.net/6031209/uploads/userpics/4OWA5DDSR8JB/n2H4UP1N6TZA6.jpg)
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)
SSFeatures - The browser extension that adds essential features into Smartsheet.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives