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
Sign in to see the current vote count, add your own vote, or leave a comment.
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
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!).
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!!!
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
I would like to have the ability add a child row to a specific parent row in a form. Like maybe selecting the parent from a dropdown. Most of the time this will be after the parent has initially been created.
Use Case: We onboard new accounts that have main Group Code for the entity and Subgroup Codes for the locations that entity has. If we could send a form that allowed them to add details for each location as child rows under the entity, that would be extremely useful. To take it a step further, sometimes these locations might have multiple addresses - like a billing address and delivery address. If the form could allow the end user to select that the location has x number of addresses and add another level of child rows for each address it would be even better.
Use case - we are managing tours of a showroom, and there are different requirements for different types of tours. For example, if the user indicates that refreshments are needed - I want a child task for the refreshment information to be added to the sheet. If they indicate that a video presentation is required - I want a child task for that. But if they do not require these things, the child task is not added. (these are just a couple of the requirements that might be needed)
Use Case: We set up job #s to encompass an entire marketing campaign, and the components within the campaign each have a sub-job # that we manually create to tie them all up into the one job #. If we could have the respective components that were submitted on the form as an automatic child row, would eliminate hours of manual work with the job #s and adding all of the respective child rows.
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
