Recognizing Children from Form Entries

Rae · 04/25/19

We are creating a sheet that most employees will use a Form to request time off. Is there a way to get the sheet to recognize the employee's name and automatically generate on the sheet under that person instead of at the bottom of the sheet?

Or is there a formula that will recognize the name and automatically generate the information under the parent?

Paul Newcome · 04/25/19

Unfortunately this is not possible. Hierarchies cannot be automated, and the forms can ONLY populate the bottom or top row of a sheet.

Depending on your needs, some SUMIFS formulas on a Metrics sheet may be a solution.

sean59916 · 04/29/19

Agree Paul - we had a similar use case for time off requests and went with a separate sheet to capture totals by person.

mag94651 · 07/14/19

how do we get the option to create a form with children? I have jobs with multiple POs and multiple line items per PO. I don't want to rely on the end user to enter the data and indent properly. Any other options? Lori

Genevieve P. · 07/15/19

Hi Lori,

At this time we do not have a way for forms to create children rows. When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.

We appreciate your input!

Recognizing Children from Form Entries

Comments

Categories