Checkbox sum for weighted score

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

Find more posts tagged with

Accepted answers

Andrew McCreath

Perfect! Thank you!

All comments

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!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.