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

Options

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

Best Answer

  • Heather Duff
    Heather Duff ✭✭✭✭✭✭
    Answer ✓
    Options

    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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!