Determine if all checkboxes are checked

Desertbird

Hello,

I have a row of checkboxes, and I am trying to come up with a formula that determines if all checkboxes have been checked, but keep getting unparseable, looks like the below screenshot.

These are two formulas I've tried but haven't gotten anywhere:

=IF(COUNTIF([Done? (10)]@row = 1:[Done? (9)]@row=1:[Done? (8)]@row=1:[Done? (7)]@row=1:[Done? (6)]@row=1:[Done? (5)]@row=1:[Done? (4)]@row=1:[Done? (3)]@row+1:[Done? (2)]@row=1:[Done? (1)]@row=1)=10,"Completed","Initiated")

=IF(COUNTIF([Done? (10)]@row, [Done? (9)]@row, [Done? (8)]@row, [Done? (7)]@row, [Done? (6)]@row, [Done? (5)]@row, [Done? (4)]@row, [Done? (3)]@row, [Done? (2)]@row, [Done? (1)]@row) = 10, "Completed", "Initiated")

Andrée Starå

Hi @Desertbird

I hope you're well and safe!

Try something like this.

=IF(COUNTIF([Done? (1)]@row:[Done? (10)]@row, 1) = 10, "Completed", "Initiated")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Desertbird

I hope you're well and safe!

Try something like this.

=IF(COUNTIF([Done? (1)]@row:[Done? (10)]@row, 1) = 10, "Completed", "Initiated")

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!