Sign in to submit new ideas and vote
Get Started

Indent child records based on formula or automation

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


25
25 votes

On Wishlist · Last Updated

We love this idea too! While it's not a part of our current plan, this is the kind of feature our team is thinking about. If we believe we can make this idea a reality we'll update the status here.

Comments

  • Mitch Cohen
    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
    Nick Pistotti ✭✭
    edited 05/16/24

    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
    Sherry Fox Community Champion
    edited 01/16/25

    @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!

    Sherry Fox

    Business Process Analyst 3 | C5ISR Group

    HII | Mission Technologies

    EAP | Mobilizer | Automagician | Superstar | Community Champion

    Original Smartsheet Profile: @Sherry Fox

  • InvitedChaos
    InvitedChaos ✭✭
    edited 01/16/25

    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.

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

  • 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