Indenting Rows automatically

Pestomania · 06/12/24

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.

Zachary Ziegler · 06/12/24

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.

Oana A. · 08/15/24

I want to do the exact same thing and I haven't found a way yet. Of course the AI they have it's also useless. I am looking into the Smartsheet API to see if there is a way to program it. I wish they added some useful features in teh EAP, rather than mostly cosmetics.

Pestomania · 08/15/24

https://community.smartsheet.com/discussion/comment/449515#Comment_449515

I had to do some workarounds and made it manual, but at least it "tells" you what to do.

Indenting Rows automatically

Answers

Categories