How to count amount of times an email address appears in the "Created By" column?

Hi, I am using a form to receive IT tickets. Within the main sheet, there is an automated "Created By" column which captures the email address of the form submitter.

I want to count the amount of times that each email address within the "Created By" column appears. If this could be done between date ranges that would also be great (i.e. in the past 6 months).

I have been looking through the community but haven't been able to sort a solution yet.


  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭

    Hey @John Kelly

    Depending on what you want to do with the output, the easiest solution is to create a report and Summarize (count) the names. A report will always be dynamic in keeping any new email addresses in the count. You can bring the data from this report in a dashboard

    If you want a specific, dynamic, date range, you may need to add a helper column (checkbox) to help filter the report. For 6mos (180d) the formula to check the box if the created date was in the last 6 mos is this. If you decide on a different increment, the value can be adjusted. If the duration value will change frequently, let me know and we can come up with a better solution


    If you are unfamiliar with reports, this link might be helpful. If you want the step by step instructions, just let me know.


  • John Kelly
    John Kelly ✭✭✭

    HI Kelly,

    Thanks for the info. Don't think that that works for me though. When I create a report it will summarize the amount of emails in total. What I am looking to do is to see how many times each person has added a ticket. For example, we might have 400 tickets but i want to see how many times has added a ticket.

    I have no problem adding helper columns if needed.

  • ker9
    ker9 ✭✭✭✭✭✭

    Hi @John Kelly

    Try grouping your report on Created By

    Hope this helps!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!