Match Learner by Location in a Training Tracker for Metric Sheet


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()))

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!