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).