Check to see if a row is a Parent

I am trying to check if a row is a "parent". My definition of a parent is a row that has any children or a single row with no children. I have a column, called isParent, that I am adding to each row a 0 for not a parent (so a child row) and a 1 to the parent row

I can get if the row has no children with this formula =IF(COUNT(CHILDREN()) > 0, 1, 0)

but struggling with the row that has no children, I tried doing something with Ancestors, but that didn't work.




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!