Match Learner by Location in a Training Tracker for Metric Sheet

benlight

I am missing something, but I think it is because I am not accustom to working with dates. I am creating a metric sheet for dashboard.

I have a training tracker that populates a date by a learners name & demographics (row) with columns of different courses (date columns). I didn't think the formula would be difficult , but I can't isolate how many from a particular location has taken the course.

=COUNTIFS({Learner Location Range}, [Location]@row, {Course Completion Date}, HAS(DATE()))

Carson Penticuff

=COUNTIFS({Learner Location Range}, [Location]@row, {Course Completion Date}, ISDATE(@cell))

If I understand your scenario correctly, this may work.

benlight

Awesome,

Exactly it! I was not identifying the date@cell.

Thank you so very much!

Carson Penticuff

=COUNTIFS({Learner Location Range}, [Location]@row, {Course Completion Date}, ISDATE(@cell))

If I understand your scenario correctly, this may work.

benlight

Awesome,

Exactly it! I was not identifying the date@cell.

Thank you so very much!