Insert a Parent row when cell value changes

Alejandro Lamothe1

I have a very long sheet where I need to group by the key column, so I have to insert a Parent row for every different value en that column, how can I do it? 

Shaine Greenwood

Hi Alejandro,

 

You'll need to manually insert the parent and indent the children underneath as needed. There isn't a way to do this automatically within Smartsheet.

 

Otherwise, if you have development resources available, you might consider using the API to automate this programmatically: https://smartsheet-platform.github.io/api-docs/