Need formula to sum multiple selections from a dropdown column

Hello.

I have a formula in place to sum a multiple selections dropdown column to obtain a score on the next column.

However, the formula does not recognize the other selections.

Here is a screenshot of the three options. If they select the first two, then they should get a 5, not a 2.

This is the formula I'm using: =IF(CONTAINS("Designated Social time", [15 - ACL Engagement]@row), 2, 0) + IF(CONTAINS("Plus Board Members share Best Practices", [15 - ACL Engagement]@row), 3, 0) + IF(CONTAINS("Otherwise", [15 - ACL Engagement]@row), 0, 0)

What am I missing? 🤔

Find more posts tagged with

Accepted answers

All comments

AKnight

Hi @D. Rojas !

Try HAS instead of CONTAINS. It will allow you to look at multi-select options rather than just one text item. Like:

=IF(HAS([15 - ACL Engagement]@row, "Designated Social time"), 2, 0) + IF(HAS([15 - ACL Engagement]@row, "Plus Board Members share Best Practices"), 3, 0) + IF(HAS([15 - ACL Engagement]@row, "Otherwise"), 0, 0)

D. Rojas

Thank you, Ashley! That's much better. 😃

AKnight

You're welcome!!

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.