Indenting Rows automatically

Options

I have the following data in a sheet. I want to create a report (or anything that makes sense), that says if it is anything other than "Top Level", it will be tabbed over under the parent process it aligns to. Parent Process "1 - Process Details Test" aligns with Process Identifier 1.

I am hoping to have this automated. "Process Identifier" is a formula field.

Hopefully this makes sense.

This is an example of something similar.

Tags:

Answers

  • Zachary Ziegler
    Zachary Ziegler ✭✭✭✭
    Options

    I've been looking at how to do this as well, and although I found a youtube video of someone who managed it with the Jira connector, I wouldn't assume that use case fits all needs. I don't think there's a way to automate it as-is, but you can certainly speed up the process by using the keyboard shortcut ctrl+] to indent and ctrl+[ to remove a hierarchy. I would be interested to see this as a feature though, as I can see the value of being able to indent as a conditional formatting rule.