Cross-Referencing Sheets to Track Email Addresses/Form Submitters

K. Chennisi

We are planning to send out a form and are trying to figure out the easiest way to track when a person completes the form without having to manually go back and forth from the contact list sheet to the form sheet. Does anyone know how to cross-reference sheets where it will automatically check a box or indicate "Yes" when the email addresses match?

Paul Newcome

Yes. You could use a COUNTIFS to see how many times that email address pops up on the form sheet and then use an IF statement to say that IF that COUNTIFS is greater than zero, check the box.

=IF(COUNTIFS({Form Sheet Email Address Column}, @cell = [Email Address]@row)> 0, 1)

Paul Newcome

Yes. You could use a COUNTIFS to see how many times that email address pops up on the form sheet and then use an IF statement to say that IF that COUNTIFS is greater than zero, check the box.

=IF(COUNTIFS({Form Sheet Email Address Column}, @cell = [Email Address]@row)> 0, 1)

K. Chennisi

Thank you! Based on your formula, I was able to substitute the 1 for "Yes", which is what I needed. Thanks again!