Automatically Organizing Rows into Hierarchy

kelly_edutx13

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!

Alex Argumedo

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

Alex Argumedo

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