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!