Expiration Reports (push button or dropdown?)

[DaveMacdonald]

I would like to have a button, or even a dropdown, whatever that provides mewith either a report or a list of some kind of names of everyone who has an expired credential. Or if possible, to drill down further, have Excel provide a list of names with expired certifications, separated by their site... see below.

Last Name

First Name

Middle Initial

EDIPI Number

Status

Start Date

Employee Number

Site

Supervisor Training

NDA (Issued)

Recent Photo (Date)

Recent Photo (Expires)

Driver's License (Issued)

Driver's License (Expires)

Last

First

I

Active

12/1/2017

7097454

Site 1

4/13/2010

5/13/2016

5/13/2016

3/31/2024

3/18/2016

3/20/2024

This is obviously a redacted version and there are multiple sites and many more certifications, but I would like to be able to set the framework to make a report giving lists of all names at the site "Site 1" who have an expired Drivers license.

I have tried a few different things but not really getting much traction. Does anyone have any ideas?

 

[JhnSanchez]

I would use a filter formula (=Filter()) to search and display the records with expired driver's license.