Automatically adding rows to sheet and automatically nesting them under parent row?

Julia C Peterson

Is it possible to have a rows automatically added to a sheet (for instance from a form on another sheet), and have the rows automatically be nested under the correct parent row on the target sheet? For example, if the Primary column is "project name", and "parent project name" is a field on the form, is there any way for Smartsheet to automatically add that new row as a child row under project name when project name = parent project name?

Genevieve P.

Hi @Julia C Peterson

There currently isn't a way to organize rows automatically into different hierarchies through form submissions (please submit your feedback to our Product Team through this form, here!)

As an alternative, you could potentially set up a Report based on this sheet and then Group the Report by the Parent Project Name to organize your data. See this Help Article for more information: Configure Grouping to Organize Results in Report Builder

I hope that helps!

Cheers,

Genevieve