Helper Column Parents and Tasks with 0 Children

Helper Column Parents and Tasks with 0 Children

I am using this formula in a helper column to identify which of my rows are "parents" however I would also like to Identify Rows that are Projects or also "Parents", but have 0 children " so that I can tag in conditional formatting along with my Parent Rows that have children.  Can you help me create a formula that can do this?

=IF(COUNT(CHILDREN([Project Name]@row)) > 0, "Parent", "")

 

 

Example Parent 0 children.jpg

Comments

Sign In or Register to comment.