I am trying to find a formula to pull information submitted from forms to a master sheet. We are attempting to use Smartsheet to keep track of training requirements for different projects within our company. Some of these projects may have to multiple trainings that they have to complete each Option Year. I have attached a screenshot of the Data sheet for the form submissions.
How do I take these multiple entires and combine them into one row on another sheet to show if they have completed all their required trainings for that year? Most the formulas I have tried stop once they see the identifier and do not continue to search. Below is the Master Sheet I have created, but I am open to any other suggestions/changes.