Cross-Referencing Sheets to Track Email Addresses/Form Submitters

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?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!