Insert form data under a specific parent/child row

Aneesah Serrano
Aneesah Serrano ✭✭✭
edited 02/10/21 inSmartsheet Basics

你好,

I've created a hierarchy and now looking to create a form to gather data to be placed on a sheet. I'm familiar with setting up forms that pull under specific columns, but what I'm needing to do here is enter an individual's name under a specific 'child' row.

Using this screenshot as an example, I'm needing a candidate's name to be placed under a specific location (Hillcrest, Memorial, etc) under the specific district (Grones). Essentially creating another parent/child hierarchy between the location and now candidate's name. The initial sheet will have that parent/child relationship already established, but I'll need all entries of candidate names made after the initial setup to go to the right field.

image.png


Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭

    Hi @Aneesah Serrano

    Hope you are fine, unfortunately you can't do that

    PMP Certified

    [email protected]

    www.mobilproject.it

    ☑️Are you satisfied with my answer to your question? Please help the Community by marking it as an( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi@Aneesah Serrano

    As@Bassam.M Khalilpointed out, Smartsheet forms require entirely new rows to enter information into a sheet, so a form submission wouldn't be able to automatically appear in a hierarchy (please provide your feedback to the Product teamthrough this form, here!)

    Depending on your specific process, you may want to useUpdate Requestsas your "form" instead. These are sent out from currently existing rows, so the information would be populated exactly where you need it to be. Would this work for you? See the following article for more information:Automatically Request Updates on Tasks.

    Cheers,

    Genevieve

  • @Genevieve P- Thank you. Is there a way to automatically sort a sheet by a column. We are needing to organize a sheet that supports multiple locations. However, if I'm not able to designate a specific location to place data gathered from a form (like in a hierarchy), there is no organization to the sheet and these individuals would need to look through the entire list to find their specific location where the data they need to review is; as opposed to being able to expand a parent row that labels the section they need to review.

  • Sandra Guzman
    Sandra Guzman ✭✭✭✭✭✭

    @Aneesah Serrano- I plan to submit an enhancement request as proposed by@Genevieve Psince I can see added value with having this functionality.


    你可以通过单击行column header and select sort from the list of options.

    image.png


    You may want to create a new column and pull in the information to capture the individual that is responsible for the location so that you can manage pulling data for that person. You could create specific filters that look for current user. There are even other options that require a little setup on the front end but you could create a report and filter by their name, or you could develop another supporting sheet and use to cross reference formulas that pull over the data.


    All the best,

    Ssndra

  • Thanks. I guess what I am trying to assimilate is what would be TABS on an Excel sheet. In the absence of that capability, the outdent/indent was the next best thing, but the functionality doesn't allow the flexibility of organizing the sheet the way a tab feature would.

    Best,

    AS

  • I know this is an old post, butthere is a wayto add FORM data under a specific PARENT.

    If you keep your data in a CARD view instead of a grid and add a specific field in the FORM that specifies the PARENT column name (drop-down or radio button). The FORM Data will flow to the PARENT and be inserted as the last CARD in the PARENT column.

  • To assimilate what would be TABS on an Excel sheet, I use the WorkApp that lets you list separate TABS (pages) within the same working space (within an App). when users access the App, they select the tab (page) they need to view the content.

    The added bonus is to set up Roles and assign what each user could access/view/edit. Additional pages could also be added with i.e. instructions or links (similar to dashboards)

  • ssagers
    ssagers ✭✭✭

    I also need this feature. I'd love to be able to capture data in a form and then place the info gathered as a child row based on a name in a parent row.

  • WinaHath
    WinaHath ✭✭✭

    Can we have a feature to select where a new submission should appear on the sheet? The only options we have are top and bottom. It will be great if we can specify a row number.

  • I know this is an old post, but there is a way <\/strong>to add FORM data under a specific PARENT.<\/p>

    If you keep your data in a CARD view instead of a grid and add a specific field in the FORM that specifies the PARENT column name (drop-down or radio button). The FORM Data will flow to the PARENT and be inserted as the last CARD in the PARENT column.<\/p>","bodyRaw":"[{\"insert\":\"I know this is an old post, but \"},{\"attributes\":{\"bold\":true},\"insert\":\"there is a way \"},{\"insert\":\"to add FORM data under a specific PARENT.\\nIf you keep your data in a CARD view instead of a grid and add a specific field in the FORM that specifies the PARENT column name (drop-down or radio button). The FORM Data will flow to the PARENT and be inserted as the last CARD in the PARENT column. \\n\\n\\n\"}]","format":"rich","dateInserted":"2022-12-12T19:30:38+00:00","insertUser":{"userID":155910,"name":"Dorota P","url":"https:\/\/community.smartsheet.com\/profile\/Dorota%20P","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-12-12T19:25:14+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/354036#Comment_354036","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/354036#Comment_354036

    @Dorota Pthis intrigues me, but I don't fully understand the concept. Would you be so kind to add screen shots to explain in more detail?

    Thanks!

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    @Paul BilbroThis doesn't actually do any indenting or anything. It simply drops a new card into the appropriate lane, but when you switch to grid view, you will see that all new entries are still going to the bottom of the sheet and not being placed under any actual parent row.


    image.png


    image.png
    image.png


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    My recommendation if you have groupings you want to manage but are using forms for data entry is to do away with hierarchy all together in your data collection sheet and use columns/form fields to indicate which group the entry belongs to.


    From there you can use Grouping in a report and/or formulas with cross sheet references in a metrics sheet to get whatever metrics you need from the data.

  • @Paul Newcomethank you for the examples! I fully understand now.

Fixed, needed to add \"Value\" before the formula to remove the apostrophe.<\/p>


<\/p>

=VALUE(IFERROR(JOIN(DISTINCT(COLLECT([Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, [Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, <>\"\"))), \" \"))<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109460,"type":"question","name":"IF \/ OR formula then Check a Box","excerpt":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1) OR([Study Status]@row = \"In Start-Up\", 1))","snippet":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1)…","categoryID":321,"dateInserted":"2023-08-25T13:30:39+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T16:21:27+00:00","insertUserID":9250,"insertUser":{"userID":9250,"name":"Susan Swisher","url":"https:\/\/community.smartsheet.com\/profile\/Susan%20Swisher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T16:23:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T02:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":48,"score":null,"hot":3385956126,"url":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109460,"commentID":392616,"name":"Re: IF \/ OR formula then Check a Box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392616#Comment_392616","dateInserted":"2023-08-25T16:21:27+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-27T02:16:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T15:13:03+00:00","dateAnswered":"2023-08-25T14:14:39+00:00","acceptedAnswers":[{"commentID":392575,"body":"

Give this a try:<\/p>

=IF(OR([Study Status]@row = \"Active\/Open to Accrual\", [Study Status]@row = \"In Start-Up\"), 1)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109457,"type":"question","name":"Conditional Formatting (modified date not in the last 3 weeks)","excerpt":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated (last 3 weeks) should be highlighted in yellow. Is this spmething that can be done directly within conditional formatting or should I first create a…","snippet":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks. So any row that has not been recently updated…","categoryID":321,"dateInserted":"2023-08-25T12:33:14+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161267,"lastUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":28,"score":null,"hot":3385935251,"url":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":109457,"commentID":392553,"name":"Re: Conditional Formatting (modified date not in the last 3 weeks)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392553#Comment_392553","dateInserted":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T12:40:09+00:00","dateAnswered":"2023-08-25T12:37:47+00:00","acceptedAnswers":[{"commentID":392551,"body":"

There is no direct way to do this. Adding a checkbox helper column with something similar to this and then formatting based on the checkbox is the simplest way. You can even hide the extra column, as there is no reason for it to be visible.<\/p>

=IF([Modified Date]@row < TODAY(-21), 1, 0)<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":4991,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

Trending in Smartsheet Basics