Hi there.
I've created some internal MS Forms for my company that are attempting to gather information from a requestor regarding the skillsets they are looking for. There is another form for volunteers who can submit their level of expertise across those same skills. The goal is to have the logic on the Request tab -> column 'Best Matches' display the ID numbers (separated by comma, text join?) ranking them from highest matches to lowest for only top 3.
On the skills logic tab, I've created a value associated for each level of expertise. If a requestor asks for an intermediate in Tableu, and there are two records in volunteer, where as one is intermediate, and the other is Expert, The one with Expert should be returned first, where as the other would be returned second.
I'm not sure if it's possible to add up all of the associated points across all the matches, rank them, then return only the ID of Volunteers of top 3 in single column. This seems like a combination of arrays, rank & or big, but I'm unable to come up with anything. Maybe there needs to be one column on the Request tab for each skill i.e. Tableau rank, Sharepoint rank. Maybe that's easier to return the top 3 with out adding in the sum of the entire array into one column?
Struggling to find an elegant solution to this one. Any help would be amazing :-)
Tableu
Sharepoint
Power BI
Smartsheet
MS Excel
MS Word
MS Powerpoint
MS Project
Bookmarks