Indent child records based on formula or automation

Celia Gust

When adding new rows to a sheet, with a Parent ID number, the child line should indent under the Parent line. In the picture, When the child record Celia is added from a different sheet, via automation, it lands at the bottom of the sheet. We can do a sort by Parent ID and it will move the the right spot, but it's not indented. The indent has to be done manually. The request is to allow automated indenting, based on a formula or an automation (it could be part of the Move Row automation).

Mitch Cohen

It would be very helpful to have a process to automatically indent a line if a criteria was met. Maybe a conditional formatting feature.

Nick Pistotti

Hello! Id love to be able to "automate" a simple indent/outdent function.

My hope is to have a formula that says if "column A" value = Child, then indent that row

Sherry Fox

@Nick Pistotti ,

I am basically doing many parent/child tasks manually. We highlight the parent row, but not the child. That is the the one I remember most, but there are others. Down the far right side, there is a column with either parent/child. All of the sheet formulas populate based on this information. But I would love to add the indentions to the list!

InvitedChaos

This would be amazing! I'm trying to automate a purchase req system right now and struggling to work around the issue of multiple-line requests needing to be under a single ID. It's PAINFUL. If there an automation to duplicate the line based on a cell value, maybe with a particular cell value copied to create the child, and make the original line its parent, that would solve SO MANY ISSUES my company is having with using SS to automate our manufacturing and administrative processes.

If you do implement this, PLEASE ADD IT TO THE GOV SIDE AS WELL. I understand the cause of the limitations and rollout lag, but's so painful to miss out on some of the best features.

Matthew W Martin

A workflow to move a child row or assign a newly entered row (i.e. from a form) based on the contents of one of the cells in that row to one of the parent rows on the same sheet.

George Manolas

Yes,

"A workflow to move a child row or assign a newly entered row (i.e. from a form) based on the contents of one of the cells in that row to one of the parent rows on the same sheet"

would be of great benefit