Recognizing Children from Form Entries

Rae

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

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.