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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
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
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now -
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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives