Check box in sheet when email address entered in a form matches an existing email address in a sheet
Hi,
I'm trying to get my dashboard on employee training to automatically remove rows from a report when a specific user responds using a form. I have the responses from the form automatically moving to another sheet/report, but then I want that user to be removed from the 'yet to respond' report in the dashboard.
My thought was to check a box when the email address entered in the form matches the master employee list, but I'm having trouble getting cross sheet formulas to do this the way that I would like. Any ideas?
Best Answer
-
Try something like this on the sheet being used for the report...
=IF(CONTAINS([Email Address]@row, {Master List Email Address Column}), 1)
This will check the box if the email address is found anywhere in the Email column of the master list.
Answers
-
Try something like this on the sheet being used for the report...
=IF(CONTAINS([Email Address]@row, {Master List Email Address Column}), 1)
This will check the box if the email address is found anywhere in the Email column of the master list.
-
Thanks so much Paul.
The way I have it set up, I want it to check a column in the master list. I was able to make it work the way I want by doing a little bit of re-arranging of your function by searching how to actually perform a CONTAINS function.
What ended up working for me was :
=IF(CONTAINS(([Email Address]@row), {Employee Training Form Responses Range 1}), 1)
Thanks so much for your help, and I hope my response helps someone else down the line.
☮️
-
My apologies for getting the sheets mixed up, but I am happy to have helped get you on the right track. 👍️
As a note... You actually do not need the parenthesis around [Email Address]@row. It may not seem like to o big of a deal on a formula as straightforward as this one, but extra parenthesis can become a mess fast when you start getting into the more complex formulas.
-
This was just what I needed, thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!