Hello all,
I would like to know how to, when "PASSED" is selected in 'Report Responses' A column, and "Sit Along 3" is the value of J column of 'Report Responses', Column F, Column C, and the DATE ONLY from Column B are shown on a new line in 'Trainee's Cleared for Eval' for each new submission that is marked "PASSED".
https://docs.google.com/spreadsheets...it?usp=sharing
This is an example of the sheet, and it has two current tests to show desired results, the only thing I would like is to automate it when selecting "PASSED" and it being a "Sit Along 3", it automatically adds it to that sheet.
Bookmarks