Complex IF statement between two sheets with a checkbox
I am having trouble figuring out how to create a formula. I have one sheet "Step 1-Validations-CBRE" that will contain a full list of vehicle IDs and another sheet "Fleet Inspections" that will contain the submissions for vehicle inspections.
Ultimately, I am trying to determine which vehicles have had inspections completed for the current week and easily see which ones have not. I have the current week formulas working fine. I just now need a formula in the "Step 1-Validations-CBRE" sheet.
I tried to illustrate what I am looking for below. Is anyone able to help me determine the appropriate formula? Thank you!!
Help Article Resources
Check out the Formula Handbook template!