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!

Find more posts tagged with

Formulas

Automations

Accepted answers

All comments

Paul Newcome

This is definitely an API question. I know it can be done with the API, but I can't tell you how. I just know that I have seen it done before.

kelly_edutx13

Ok thank you Paul, I will ask this question in the API community.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.