there are some audits where the data usage field is “No” but then some of the data fields are populated. I would like a table that shows me which audits this is occurring for. Example is Audit Code E22 004, Data Used = No however some of the data fields below are populated.
Data Fields:
Data Objective
Sourcing Data – Tools Used
Sourcing Data
Data Manipulation
Visualization
Benefits Derived
Hours to Build
Hours Saved
These are all of the audits that have selected “No” for Data Usage (Yes/No). All of the data field names are highlighted in blue. For the Quality Control sheet, I want to see all audits where there is a data field highlighted in yellow. Meaning they said No they did not use data on the audit but answered the data questions as if they did use data on their audit.
