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
I could use that functionality as well
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:
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
This would be really helpful in my situation too!
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?
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!).
Project Coordinator
This is a great request that I can definitely put to good use!
Holy cow, I am SO HAPPY to hear this is on the roadmap!!!
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
This opens the door for so many applications.
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.
+1 for me on this feature!
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