Summary Status on Parent Row

hedelgad

Hi -

My apologies if the answer is somewhere in the community but I can't seem to find it.  I have a project sheet and in it, I have a (RYG) status column.  I would like a status symbol to appear in the parent rows.  How do I achieve this?  I've attached a small screen capture to illustrate where I would like the status ball to appear.

 

TIA

Helene

 

 

Chris Cozad

Hello, try using the countif(children() formula

  =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green")))

hedelgad

Hi Chris -

Thank you for taking the time to answer my question.  I tried that but got an #unparseable back.  Here is what I wrote:

=IF(COUNTIF(CHILDREN(),"Red")>0,"Red", IF(COUNTIF(CHILDREN(), "Yellow")>0,"Yellow", IF(COUNTIF(CHILDREN(), "Green)>0,"Green")))

I remove some spacing in between the commas to see if that helped but received the same error.

hedelgad

Hi Chris -

I noticed I had left a quotation mark after Green.  I fixed it and it worked.  Thanks a million!!

 

Helene