Form Submission to Rollup

I've been thinking about this for a while.. I would like to take the laggy and awkward pivot middle-man out of the process.

I think there should be an option for sheet with a form to add the new row according to a rollup and sort.

For example:

  • the form asks for pencil color, length and quantity
  • I enter Green, 127mm and 3
  • I want that entry to be added as a child of "Green" in the correctly sorted length.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!