I have been tasked with the following and my brain is in a muddle trying to figure it out. If anyone has any ideas or it is a glaringly obvious solution I would be extremely grateful.
The company has a strict training system with around 40 modules that need to be completed and refreshed at set intervals. They want to be able to see who has completed what, what is due to be done or refreshed and what has yet to be completed by each staff member.
In an ideal world I would like to have a project that has a list of staff paired against the modules with a “complete” “Due” “Incomplete” field clearly visible with a green/orange/red colour. Even more ideally to have it automatically tied to a dating system that I could perhaps input somewhere so that these fields do not have to manually changed.
I am aware each project has a limit of 20 custom fields so it could be split across a couple of projects.
I believe it will involve multi homing and setting up rules but I just cannot connect the dots quite right.