Automatically Organizing Rows into Hierarchy
Hello SS Developers!
I am both a formula and API-deficient SS user. I believe my question should be directed toward the API/Developer community, as I asked the AI formula developer tool to create a formula for this request and it stated, "Smartsheet formulas cannot be used to automatically organize rows into hierarchy".
I have created a form that will collect data into a sheet, with a parent row with the formula: =Count(CHILDREN[Session Name]@row))
Each form creates a new row, and I would ideally like each row to come into the sheet as a child to that parent row. Currently, I have to manually drag each row under.
Perhaps there is an easy way to achieve this, but I was doing some API research on webhooks, callback notifications/objects. Would this be the correct direction I should be looking in to create this type of automated row hierarchy organization?
Any and all insights are much appreciated, thank you to this wonderful community for your guidance!
Best Answer
-
It is possible, but unfortunately, no easy way, but in general: Any row can be updated to do the following:
- Go to the top of all rows
- Go to the bottom of all rows
- Designate a parent row and place at the top of the child list
- Designate a parent row and go to the bottom of the child list
- Indent and Outdent
But if this is the first time you are using the API I would recommend to check the documentation about row positioning : https://smartsheet.redoc.ly/tag/rowsRelated#section/Row-Include-Flags
row update: https://smartsheet.redoc.ly/tag/rows#operation/update-rows
and adding rows: https://smartsheet.redoc.ly/tag/rows#operation/rows-addToSheet
Answers
-
It is possible, but unfortunately, no easy way, but in general: Any row can be updated to do the following:
- Go to the top of all rows
- Go to the bottom of all rows
- Designate a parent row and place at the top of the child list
- Designate a parent row and go to the bottom of the child list
- Indent and Outdent
But if this is the first time you are using the API I would recommend to check the documentation about row positioning : https://smartsheet.redoc.ly/tag/rowsRelated#section/Row-Include-Flags
row update: https://smartsheet.redoc.ly/tag/rows#operation/update-rows
and adding rows: https://smartsheet.redoc.ly/tag/rows#operation/rows-addToSheet
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives