Is it possible to get rows automatically sorted in a sheet as new rows are added?

ro.fei

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.)?

marc4

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

SSFeatures

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!