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.

Find more posts tagged with

Accepted answers

All comments

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(Created@row>=TODAY(-180),1)

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

https://help.smartsheet.com/articles/2482083-summarize-content-to-extract-key-information-with-report-builder

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 thomas@anemail.com has added a ticket.

I have no problem adding helper columns if needed.

John Kelly

Bump

ker9

Hi @John Kelly

Try grouping your report on Created By

Hope this helps!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.