Formula for percent match to a multi select column

eceisin ✭✭✭
edited 12/09/19 in Formulas and Functions

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?






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!