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

Christine Salmon
Christine Salmon ✭
edited 12/09/19 in Archived 2016 Posts

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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • Ted Cochran
    Ted Cochran ✭

    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.

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories