Hello,
I have a data collection sheet that stores a variety of sites data. I will do my best to explain the setup, as well as desired outcome.
This sheet contains two forms, (1) a data collection form used for new sites [requires 3 Point of Contact (POC) emails, site name, and various other fields that will not be referenced] and a (2) data collection request form used for sites who wish to have their original entry resent to themselves [Requires email, site name, and will automatically use a checkbox] . In order to make this process automated, I was trying to create a work flow that references site and emails.
The Data Collection Request sheet automatically uses a checkbox for a column (Requested). It also required the requestor input their email (Requestor Email). When creating the workflow, I want the Requestor Email field to reference at least 1 (at most 3) other columns that are submitted with the original form (IT POC, GM POC, and/or Leadership POC). If the email address submitted in the Data Collection Request form matches any of the emails in the other fields AND the site name, I would like to have this trigger that row to be sent in an email to the Requestor.
Is this possible? Any guidance is appreciated! Thank you!
**Edited**