Check a single box based on multiple Harvey balls
I have multiple rows listing activities for items A through J (arranged as columns). Each item has a Harvey ball to show its completion - e.g., half, three-quarters, full, etc. I would like for a checkbox column to be checked when all items' Harvey balls are full.
What I want to do is this:
=IF([Item A]@row:[Item J]@row = "Full", 1, 0)
But I keep getting INVALID OPERATION. Help??