Bridge sort sheet by two columns
We're using an HTTP Call to sort a sheet based on the values within a column.
Is it possible to sort by TWO columns within the same query? If so, I'd be grateful to know how the parameter body should be updated to accommodate.
E.g. Sort by "Manager" then "Resource Name"
Form Parameter - Body = {"sortCriteria": [{"columnId": 3400991145518980, "direction": "ASCENDING"}]}
Best Answer
-
Yes this should be possible! I haven't tested this directly in Bridge but I know you can do it using the Smartsheet API.
Here's the documentation on row sorting, and here's the information about the SortSpecifier Object.
This is what an example Body would look like:
{ "sortCriteria": [ { "columnId": 11111, "direction": "ASCENDING" }, { "columnId": 22222, "direction": "ASCENDING" } ] }
You'll want to list the column IDs in order of priority. Let me know if this works for you!
Cheers,
Genevieve
Answers
-
Yes this should be possible! I haven't tested this directly in Bridge but I know you can do it using the Smartsheet API.
Here's the documentation on row sorting, and here's the information about the SortSpecifier Object.
This is what an example Body would look like:
{ "sortCriteria": [ { "columnId": 11111, "direction": "ASCENDING" }, { "columnId": 22222, "direction": "ASCENDING" } ] }
You'll want to list the column IDs in order of priority. Let me know if this works for you!
Cheers,
Genevieve
-
@Genevieve P. - you are amazing, your suggestion worked perfectly. Thank you for responding so quickly!!
Zeb
-
No problem - glad to hear you got it working! 🙂
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives