Rename Levels

AnneSh

I'm reviewing this discussion but have a question related;

https://community.smartsheet.com/discussion/74316/levels-formula

What I am trying to achieve is to create Alias's for the following;
When level is 1 call it "Header"

Where level is lowest level number child call it "Task"

Ignore everything else, for example; first child is still a header but its not an important header of the groups I am looking for. I'm only wanting an alias for the group name/ header, and lowest level children which are tasks. I have a helper column, but stuck because the lowest children/ tasks level number changes if sub-headers are present.

Thank you!

AKnight

Hi AnneSh!

You will likely have to include a helper column for children rows which is: =COUNT(CHILDREN()). At this point you can use a formula as such:

=IF(Level@row = 1, "Header", IF(Children@row = 0, "Task"))

Hope this helps!

Andrée Starå

https://community.smartsheet.com/discussion/133135/rename-levels

Hi,

I hope you're well and safe!

Here's another option.

I usually add a helper column called Level with the formula below. You can then use it to identify parents, use it for conditional formatting, and more.

=IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!