I’m trying to design a HR/ Training Block to track certifications for our employees.
I have a block set up with 4 sheets, Staff Database (all the personell info); A Training Record ( uploads who has done what and tracks when it’s due to expire; A Job Roles Sheet (tracks what each role needs certification for; and Certification Sheet (tracks the details of each certification)
I set up a pivot table that easily shows all the staff and who has what qualification.
I have views with each person’s current qualifications and when they expire
What I need help with is showing all qualifications an individual person needs based on their role, including which they have (and when that’s due to expire) and which they haven’t even got yet (this bit is the missing link!)
Here’s a link to the block - https://airtable.com/shrpCRJ9QIN17Vx4o