I have a form that is completed by 16 different entities for 57 unique roles, filling a master sheet. I want to utilize the Dynamic View function, but also have prefilled fields and use a MATCH function from the master sheet to the dynamic view to match the input to the unique roles. The purpose is that there are a finite number of roles available and this would give the viewer the comprehensive list to see what is missing and what has already been completed.
As far as I can tell, I cannot add an additional field to a Dynamic View and create an order with all possibilities presented. I tried cell linking, but I would need to know the cell in order to link it, and the form input is at random from the 16 entities. I have also created a new sheet for an entity and written formulas referencing the master sheet, but any changes to the entity sheet do not reference back to the master sheet and I want to maintain one master sheet.
I have researched and come up with nothing that provides the viewer the entire list as a system of checks that they have input for each role. Can someone please help with a potential solution?
Thank you!
