Is it possible to get rows automatically sorted in a sheet as new rows are added?
Options
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.)?
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