COUNTIFS not picking up some values - Name / Email

I am trying to count the number of Submissions by Submitter. The Submitter uses a Form to enter a line on the Sheet. They identify themselves by email address on the Form. The COUNTIFS formula I'm using at first seemed to get hung up on whether the form displayed a name (for the contact) or the email address. I've updated all Submitter Fields to include a name on the contact, but I'm still getting inaccurate counts. What am I doing wrong?

=COUNTIFS({Communications}, =1, {Submission Date}, >=DATE(2023, 1, 1), {Submission Date}, <=DATE(2023, 12, 31), {Submitter}, Category@row)

The Category@row field is referencing the name of the Requestor.

Find more posts tagged with

Accepted answers

All comments

heyjay

Your formula seems correct. Without seeing the complete table or providing more details about the error, it would be diffult to identify the problem.

KPH

I think the problem could be that you are trying to match a name (in category) to a contact (in submitter). Adding the name to the email address in submitter won’t make it match a name in category. Could you use email address for both?

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.