How to indicate a row is a Parent row Yes/No

Ngan Bui

Hello,

I need to create a column where it indicates if the row is a Parent row. I tried with =Parent() but it does not return anything. I need this column to create a lot of other formula columns where different conditions apply.

In Microsoft Project, they have a default column call "Summary", which does the same thing. It tells you if this row is a summary row or not (see picture). I would appreciate if you can help to build this one. Thank you.

Regards,

Ngan

Heather Duff

Hi Ngan,

Try this:

=if(count(children())>0,"Yes","No")

This should count how many children that row has, and if it has any, it will display yes; otherwise, no.

Best,

Heather

Heather Duff

Hi Ngan,

Try this:

=if(count(children())>0,"Yes","No")

This should count how many children that row has, and if it has any, it will display yes; otherwise, no.

Best,

Heather

Ngan Bui

Yes, it works. Thanks Heather. I am impressed by the speed of help from you!

Heather Duff

Happy to help! Have a great day.