Is there a way to set up a statement based on whether or not a cell is a "Parent?"

Sarah Tavarez

If X cell is a "Parent" cell, I want the data outcome in Y cell to be 1.

If X cell is not a "Parent" cell, I want the data outcome in Y cell to be 0.

Andrée Starå

Hi @Sarah Tavarez

I usually add a so-called helper column called Level with the formula below, and then you can use it to identify parents and use it for conditional formatting and more.

=IF(COUNT(CHILDREN([Task Name]@row)) > 0, COUNT(ANCESTORS()) + 1)

Would that work/help?

I hope that helps!

Have a fantastic day & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!