Multi Select Dropdown, Adding Values

I created a column with a multi-select dropdown. I would like to add values for each selection and then create a formula to add the values together.

Example:

Column Name: Findings

Multi-Select Options: Subawards, Effort, Late Charges, Reporting

If someone selected Effort, Late Charges and Reporting, I would like the next column, Findings Risk Score to give each of those selections a value and then add the values together. I'm not sure yet if each selection will have the same value or if the values are weighted, so I would love to hear solutions for each.

I have used the IF statement to give each selection a value, but I've only used that in singe-select dropdowns.

Thanks so much!

Find more posts tagged with

Accepted answers

Leibel S

@Jessyo

You can use the HAS function and keep on adding as many IF (preceded with a + sign) functions you need. See below example:

=IF(HAS([Findings]@row, "Effort"), 5) + IF(HAS([Findings]@row, "Reporting"), 7)

All comments

Leibel S

@Jessyo

You can use the HAS function and keep on adding as many IF (preceded with a + sign) functions you need. See below example:

=IF(HAS([Findings]@row, "Effort"), 5) + IF(HAS([Findings]@row, "Reporting"), 7)

Jessyo

@Leibel Shuchat

Thank you so much! That is exactly what I needed!

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.