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

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

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

John

Find more posts tagged with

Formulas

Hi John,

Try this:

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

Thank you!

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.

Try this:

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