Automated Workflow - Triggering Alerts to Emails in Column on Sheet
I was setting up an automated workflow for one of my sheets but ran into an issue. I want to alert the person (whose email address is a data cell on the sheet) when the status of a cell has been changed to "Order Completed". The trigger conditions for the workflow are fine and make sense but how can I designate that the alert needs to go to the email of the person who submitted the form (the email address is an actual field on the form)? The only options I have are to send to specific people, send to contacts in a cell, and other options that do not apply. Is there something else that I need to change in order to be able to do this?