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.
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
I’d like to see user analytics for WorkApps. I’ve checked the user report available in the Collaborator Pack, but it only shows how many times someone has clicked into the WorkApp each month. I’d like to know: Which resources (dashboards, sheets, forms, etc.) are getting the most traffic? Where are people spending their…
