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.


  • heyjay
    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
    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?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!