Count only if Parent
I have a [RowID] column that is populated by this formula
=IF(ANCESTORS@row = 0, COUNT($ANCESTORS$1:$ANCESTORS@row, "")) It returns sequential numbers but, I need it to only count if Ancestor = 0
Secondly, I need the result fill format to look like this 0000 (like an auto number)
Help Article Resources
Check out the Formula Handbook template!