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
-
=COUNTIFS({Learner Location Range}, [Location]@row, {Course Completion Date}, ISDATE(@cell))
If I understand your scenario correctly, this may work.
-
Awesome,
Exactly it! I was not identifying the date@cell.
Thank you so very much!
Answers
-
=COUNTIFS({Learner Location Range}, [Location]@row, {Course Completion Date}, ISDATE(@cell))
If I understand your scenario correctly, this may work.
-
Awesome,
Exactly it! I was not identifying the date@cell.
Thank you so very much!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.7K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!