User Certification Report

I am writing a Smartsheet User Certification Tracker template for each user in our organization.

There are only two columns, the Certification Name and a Date column.

I want to have a Report on each person that only shows Certifications for which there is a date in the date column.

Is this possible?

Tags:

Best Answer

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 09/13/23 Answer ✓

    Hi @SEBERCAW,

    This is definitely possible. On your Report, set a Filter for "Date Column - Is not blank"

    Then you will see all Certifications on your Report that have a date in the Date Column.

    Here is my test grid:





    Here is setting up the Report:

    Here are the results within the Report:


    Hope that helps!

    BRgds,

    -Ray

Answers

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    edited 09/13/23 Answer ✓

    Hi @SEBERCAW,

    This is definitely possible. On your Report, set a Filter for "Date Column - Is not blank"

    Then you will see all Certifications on your Report that have a date in the Date Column.

    Here is my test grid:





    Here is setting up the Report:

    Here are the results within the Report:


    Hope that helps!

    BRgds,

    -Ray