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??

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!