Need a Formula to Count repeated values in both cells

Gajapathi Muniyappa

Here India and US are repeated in both cells, hence I need the value 2 via formula. Kindly help.

NickStaffordPM

Hello!

How many countries do you have as options? Is it just those three?

Gajapathi Muniyappa

@NickStaffordPM I have more than 50 plus countries in the options, I just updated 3 as a example.

Georgie

Hi @Gajapathi Muniyappa,

There currently isn't a way to compare values within two different multi-select columns. You’d be able to check if a specific value is located within either column by specifying that value within your formula, but it’s not possible to compare values between the two columns without parsing out the multi-select columns.

Check out the following related threads for more information: 

• Comparing one multi-select field against another
• Compare 2 Multi Select Drop Down Columns

I found a similar idea post here: Add function to retrieve values from cell for a multi-select column. Please add your vote to this idea if it matches your request. You’ll then receive updates when the status of the idea changes! 

If the request provided doesn’t quite match your suggestion, please create a new Idea Post in the Smartsheet Product Feedback and Ideas topic. This will allow other users to vote on your enhancement idea!

Thanks,

Georgie