Hierarchy and Child IDs

Good morning. I have to create 2 forms which will populate parent rows and child rows. I need the parent rows to have a unique quote ID (have this set up now), and child rows to either not have an ID, or have a specific ID that will tie back to the specific quote number. How do I do this?


  • I will also need to create formulas to sum the totals of the child rows into the parent row, without messing up other column formulas. There will be multiple part numbers, but the total values and weights of the shipments etc, will need to be totaled into the parent column.

  • Mike TV
    Mike TV ✭✭✭✭✭✭


    You cannot automate indenting and creating child rows with a form, automation, formula, etc.


    This formula you can put in the Parent row and it will SUM all of the children rows under it in that column.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!