Formula for checked fields
I have a sheet that is tracking tasks and I've made it so that there are 10 contact list columns followed by 10 checkbox columns. Each contact list is paired with a checkbox to indicate if an item is done like in the image below:
I want a final column to indicate if every assigned checkbox has been filled out, without any unassigned columns interfering with the outcome (for example if there are only 2 people assigned). The final column will be used as a conditional formatting indicator for our calendar, so a single "yes" response would suffice if all assignees have checked their box. How would you recommend building a formula like this?
Help Article Resources
Check out the Formula Handbook template!