Any help is appreciated. Also, if anyone can recommend which training/certification class would be better to deep dive into the formulas and workfflows for these types of specific tasks, I would love the recommendation.
I have Registration forms for 2 separate trainings (Training 1 Registration) and (Training 2 Registration); results go to their respective grids.
Reports are used to mark attendance using checkboxes to indicate checked in or no-show for respective Training (Training 1 Attendance) and (Training 2 Attendance).
Separately, there is (will be) a grid sent/uploaded each month containing the current months active roster with names and corresponding company name (Partner Rosters).
I would like to cross check the (partner rosters) list with the 2 separate training attendance reports (Training 1 and Training 2). If the name of the roster does not have a match on either attendance report I would like for them to dump into a separate report (Not Trained).
Thank you!