Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Count unique

Each month I run a report for training attendees.  I have sorted by month and have the count of attendees per month then year.  I created a filter for each course that will provide the number of attendees for that course.  I  need to create a formula that will count each unique attendee for the year and then list all of the courses they took as well as each unique course then the attendees for the year.  My dorector does not want to use the filters I created.



  • Hi Christine,


    I just sent you an email.  I'll take a look and then we can post it back here.



    For what it's worth, Reports are an excellent alternative to filters and also allow you to provide a more customized view with real-time updates.

This discussion has been closed.