How to Programatically Collapse All Through Smartsheet API
Hi,
I have an automation that builds a smartsheet nightly but every time it does, it leaves everything expanded. I know how to collapse all in the UI. I want to do this step with automation so when the user hits the sheet, it's collapsed after a run.
Reading the API documentation, I see you can do this on a per row basis. Ok, I understand that but that would mean I'd need to run a script to find every row that's a parent and then send a command to expand=false. It'll work, but it's certainly not easy or elegant.
Is there a way to do this at the sheet level through the API? Like a command that will collapse all rows in the sheet? I didn't see this in the documentation and I only saw ['expanded'] at the row level.
Answers
-
Hey @SergeantPup
I believe you're correct - there isn't one direct command to collapse all… you'll need to find each Parent row and set them to expand=false.
Please submit your feature request to the Product team by creating an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community.
Thank you!
GenevieveJoin us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
thanks, for confirmation. I've done exactly that and I'll build a script to identify all the parent rows, then collapse.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives