How to write a formula where the "parent" and "regular" rows =0, but children rows = 1?

MightyBlues24

I am creating a new "helper column" where I'd like to have the parent rows and the "regular" rows= 0, but children rows = 1?

Kelly Drake

You should be able to get there using

= COUNT(ANCESTORS(insert your column@row here))

That should return 0 for all top level parent rows & rows without any children but the children rows should result in 1. (If you indent more than one level the middle will be 1 and the most inner/indented will be 2 and so on…

Kelly Drake

You should be able to get there using

= COUNT(ANCESTORS(insert your column@row here))

That should return 0 for all top level parent rows & rows without any children but the children rows should result in 1. (If you indent more than one level the middle will be 1 and the most inner/indented will be 2 and so on…

MightyBlues24

This worked like a dream- thank you so much!