Workflows and Conditions
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!
Help Article Resources
Check out the Formula Handbook template!