RYG(B) Balls - How do I reference the value of child cells belonging to neighboring cell/column?

John Santoski

=IF(children([Finding Status]11)="Closed", "Blue", "Yellow")

 

The above attempt is failing me (i.e., "missing or invalid parameters").  Any advice?  Thanks!

 

John

Kara Lumley

Hi John,

Try this:

=IF(COUNTIF(CHILDREN([Finding Status]11) ....

Thank you!

John Santoski

Not working for me, Kara, but I'll peruse the other Smartsheet Communities as I'm sure there's a solution out there.  Thanks, though.

Kara Lumley

Try this:

=IF(COUNTIF(CHILDREN(Status1:Status10), "Closed") > 0, "Blue", "Yellow")