Formula for percent match to a multi select column
Hi, I'm working matching mentors and mentees. We would like to match them based on attributes they both selected in a multi select column. As in, choose your top three competencies. Now I would like to make a formula to determine the percent match of a mentee to a mentor's selection. That is Mentee 1 selected A, B, and C. Mentor 1 selected A, D, E; mentor 2 selected A, B, E; Mentor 3 selected A, B, C. So mentor 1 should be 33%, mentor 2 should be 66%, and mentor 3 should be 100%. What is the best way to do this with the new multi select drop down columns?