This is a complex one that has been rattling around my brain for a while now. We have 26 sheets, each has a form tied to it that allows folks to enter information based on review/compliance questions. Example: AB 1.1.1 Did you observe them following rules? - If yes they receive a % score if No they receive a 0 and in the following logic/column they describe what was observed.
I need to pull just the 'No's of all 26 sheets and the descriptions that match those.
I thought about a helper sheet - but since these are Forms into a sheet - all the data is unique columns. So once copied to the helper sheet you end up with many rows and many blanks.
The end result we want is a PDF generated that summarizes all 26 areas/sheets and all the 'No' responses along with 'observations'. The idea is you'd receive an entry for each sheet for 1 site. Example: Site A responds to each form/sheet for the Audit for February - you can then look to summarize all responses for site A marked February and summarize.
I've tried a few different ways but looking for that idea that will trigger the right setup!
THANKS COMMUNITY!