Candidate and Company Matching System
I'm trying to build a way to match candidates to companies.
And then send those match notifications to both candidate and company.
So I have 2 sheets
Sheet 1 = Candidate List
Sheet 2 = List of Companies Interested
Sheet 3 = Merged Somehow Based on Department Role/Job Category and Location
Would have a unique row for each match.
Candidate 1 matches to Job 1 and Job 2
Candidate 2 matches to Job 2 only
I want to have 3 rows created for each instance of a match.
Row 1 = Candidate 1 Job 1
Row 2 = Candidate 1 Job 2
Row 3 = Candidate 2 Job 2
Please let me know if you have any ideas how this can be done.
I do have access to all smartsheet features and premium apps.