Smartsheet checkbox automation triggers email notification to email in field
Hi Smartsheet Smarties! I need your help!
I have a Smartsheet with a form that people fill out requesting time off, including their email. There is a checkbox (not included in the form) that is to identify management approval. I would like to set up an automation that would email the person who filled out the form (field: email) when the checkbox is checked.
I am able to set up the workflow up to the point of selecting the email field but am never able to select it. I'm guessing the intended use is really a column with a dropdown list of values? But I only want it to notify the submitter of the form.
Does anyone have any suggestions for me?
Thanks a Bunch!