How to calculate a completed task

Chris Edwards

I'm attempting for calculate if a observation was completed on a person, and mark them complete in the Q1 column of my driver list sheet. I have another sheet with the name Q1 SLC that has a column "Employee observed" that I want to match with the name in sheet "Driver List", column Driver Name. In the Q1 column I want to say complete.

Chris Edwards

I figured it out.

=IF(COUNTIF({Q1 SLC Range 1}, [Driver Name]@row) > 0, "Complete", "Incomplete")