I am trying to write some logic to display something for a parent in a hierarchy, but something different for its children. When I set the formula to just
COUNT(ANCESTORCELLS()) the values display as expect: 0 for the parent, 1 for the children.
However, when I try to use
IF(COUNT(ANCESTORCELLS())=0,"p","c") both parent and children display “p”.
In the image below, column F - Count displays just the count and column G - DTE uses the IF logic.
I also tried using
ANCESTORCELLS(A), no change. I noticed the same effect with
Apologies if it’s user error here.