RYG Ball Automation

dyep

Hello Community,

How do I go about writing an IF function to get a particular cell to automatically show Green when the child rows turn Green individually? Basically, I would like to see the parent row update green without the need to do it manually each time I change the status of an individual cell.

Thanks!

Paul Newcome

If you are trying to get the parent row to turn green after ALL of the children rows are green, then this should work for you...

 

=IF(COUNTIF(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green")

dyep

@Paul, Thank you!

Paul Newcome

No worries. Glad to help.