Counting number of values from one multi-dropdown to another

Chris Andrews
Chris Andrews ✭✭✭
edited 10/04/22 in Formulas and Functions

Hi All,


Hoping someone can help me with a COUNT formula please. I have 2 multi-dropdown columns and I'm wanting to count the number of selections from one column that appear in the other.


To give a bit of context, Column 1 could have "A", "B" and "C" (but potentially many options), and Column 2 could have "A" and "B". I would like a third column to display 2, as 2 of the values from Column 1 are found in Column 2.

Essentially i'm trying to do the below to achieve the skill %, but i'm struggling with the initial part of the formula

image.png

Is this possible?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!