Update request to a typed email address
I've got a form that drops info into a sheet, including a contact list. Right now, I've got several users plugged in to the field option, with automation sending them an update request when they get assigned a task. I need to be able to have a user type an email address in, and send that individual an update request. I'm running into a problem though- I can make the "send to" use the field with a typed email, but I can't set the condition to only send with a specific person being typed in.
In other words, I want a user to type an email address, and only that person receives the update request.
Help Article Resources
Check out the Formula Handbook template!