How to Programatically Collapse All Through Smartsheet API

SergeantPup

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.

Genevieve P.

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!
Genevieve

SergeantPup

thanks, for confirmation. I've done exactly that and I'll build a script to identify all the parent rows, then collapse.