Checkbox sum for weighted score

Andrew McCreath

Hi, unable to wrap my head around this so hoping some smarter folks can help me here, please!

In a row of activities, there are columns with checkboxes. Based on which ones are checked, I'd like to add the score associated with that column/ checkbox

I'd like the end column to total up the number of points based on the boxes checked. (John=10, Jane =8, Arthur=5)

Does that compute?

Many thanks in advance

Andrew McCreath

Perfect! Thank you!

Andrée Starå

Hi @Andrew McCreath

I hope you're well and safe!

Try something like this.

=IF(A@row = 1, 10) + IF(B@row = 1, 5) + IF(C@row = 1, 2) + IF(D@row = 1, 1)

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

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 or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Andrew McCreath

Perfect! Thank you!

Andrée Starå

@Andrew McCreath

Excellent!

You're more than welcome!

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