I am looking to create a formula to match candidates and job openings.
Each “job” & “candidate” have hard & soft skills wich are tags (found each in separate tables)in our base.
The goal is to create a function helping us find which candidates have the most tags (skills) in common with the tags found in the job descriptions.
Would love some help from the community.
Thx for the help.
If I understand this well, there is a shortcoming to this as Mac might have a skill “a” which is not in Job 1, thus the grouping will not show Mac and Job 1 in the same group.
Do you see what I mean?
I’m also looking for something similar. We have candidates being submitted with skill sets and need to match them to roles that are open (each in a different base) and can’t figure out how to link them.