Automatically Organizing Rows into Hierarchy

Hello Smartsheet Community,

I am yet another formula-deficient SS user. Looking for insight on a formula or function I can set up, 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 or be automatically re-organized as a child to that parent row. Currently, I have to manually drag each row under, and this will become an issue when I start having 100's coming into the sheet soon.

Would this be a question better directed toward the API/Developer community?

Any and all insights are much appreciated, thank you for your guidance!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!