Two part formula question.

Eric C

I am trying to count the numbers of cells that have a checked box and have a date within two cells for a training tracking sheet. I am trying to track who has completed assigned training only. I don't want to count the date if it wasn't required. I would like to do it for each row (each employee) and for each column (each class).

Formula suggestions would be greatly appreciated.

Screenshot 2023-05-02 092047.png

Austin Smith

@Eric C

Make the column a checkbox (can really do with any output) and try:

=if([bloodborne pathogens required]@row=1, if([bloodborne pathogens expiration]@row<Today(), 1, 0), 0)

Will tell you if they've completed a required training and if it's still in date, then you can do a count on checkboxes showing status per employee.