Forum Discussion
Formula needed to retrieve % of correct reviews for an employee, where reviews are on separate tabs.
Hello everyone! Thank you in advance for any assistance you are able to offer. I'm working in MS 365 for web on a windows cloud environment through a Citrix network. Looking for a formula that wil...
Unfortunately, I need a percentage for each review type (tab). Yes, all the reviews contain different review items. I could perhaps mirror the results to a fixed column number and then reference that. Would that be an option?
In the attached version, I made the relevant field names (column headings) the same in all sheets. For example, Review Date > Date of Review and Pass / Fail > Pass/Fail
This works perfectly! Thank you so much for the help. Very much appreciated!!