Certification Report on Individual Users
I have a sheet where the Primary Column is the name of the user. There is a Certification column that lists all possible Certifications that a user can have. The final column is a Date column.
I want to do a report that lists the user, and any of the certifications in the Certification column that have a Date and meet other criteria. This has to be done individually on each certification because some expire sooner than others and some never expire.
Is this possible?
Best Answer
-
Hey @SEBERCAW
You'll need to have the name of the User down every row. Then you can Filter by the Date column being empty or not, and Group by the Name column (if you're on a Business or Enterprise plan).
So if this is the source sheet:
Then this could be your Report:
Here's a free webinar on Reports: SmartStart: Reporting
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Answers
-
Hey @SEBERCAW
You'll need to have the name of the User down every row. Then you can Filter by the Date column being empty or not, and Group by the Name column (if you're on a Business or Enterprise plan).
So if this is the source sheet:
Then this could be your Report:
Here's a free webinar on Reports: SmartStart: Reporting
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
OK, thanks. I decided to do the following command in the Source sheet for if the certification expires in a year:
=IF(DATE@row >= TODAY(-365), 1, 0)
or this command if there is no expiration date:
=IF(DATE@row <> "", 1, 0)
Then I filtered the report by only checked boxes.
Seems to work fine.
Thanks again.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives