Need formula to sum multiple selections from a dropdown column

D. Rojas

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? 🤔

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!!