Giving a Parent Row a level score
Is it possible to give a parent row a score based on its hierarchy in the row grouping? ie The top level of grouping being level 1, next level of grouping level 2, but only where the row is a parent?
I am currently using =COUNT(ANCESTORS()) but this gives a task a score even if it doesnt have a child.
It would be great to return a level like in the image below.
I have seen it done before but its been a while and cant remember. If anyone could help, it would be appreciated.
Help Article Resources
Check out the Formula Handbook template!