Rename Levels
I'm reviewing this discussion but have a question related;
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!
Answers
-
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 463 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!