Use a form to create a parent row with children rows underneath it

Cole Frank

I want to have the form be used to create a row with child rows underneath it, so I don't have to keep doing this manually

Eric S.

I could use that functionality as well

Genevieve P.

Just jumping in here to let you know that @Paul Newcome posted an explanation of one way you could do this using formulas and workflows:

https://community.smartsheet.com/discussion/108432/auto-create-child-rows-without-bridge-or-api

Cheers,

Genevieve

Tina Thomas

This would be really helpful in my situation too!

Newcomer2

Would this work for child rows that aren't always 2 and can vary in numbers and parent rows aren't always in the same row?

kfarrell

Love this idea! Currently, every new row added to a sheet by a form has to be manually indented as a child row. It would be fabulous to be able to add the row automatically as a child to whatever parent row is closest to the bottom of the form (or top, if that's how your rows are added!).

damon.tackett

This is a great request that I can definitely put to good use!

Monique Odom-Stearn

Holy cow, I am SO HAPPY to hear this is on the roadmap!!!

KenR

This opens the door for so many applications.

Rachel Beck

It would be nice if certain values were entered in on a form, that a children row would be populated automatically with its submission. We have multiple products at sites that may need attention. I would like each product listed underneath the parent row, automatically. Instead, I have to have a column for each submission value which isn't easy to manage.

ssagers

+1 for me on this feature!

CarlaB

I've built a work-tracking system that requires users to enter standard course projects that can be a single 'segment' or have multiple segments. Adding a single-segment course is easily done via a form. However, adding a multi-segment course requires giving users edit access to the sheet & training them to enter data only in a few columns. (Other users regularly need to update other columns so locking or hiding isn't a viable option.)

I want the ability to have the form ask 'what's the name of your course' and 'how many segments', then create rows in the sheet with parent/child relationships like this:
COURSE NAME
— SEGMENT 1
— SEGMENT 2
— SEGMENT 3