Hi all,
I am new to AppSheet and am trying to have an automatic email sent when the Status column is changed to "Not Started". I have a tracker table in sheet 1 in Google Sheets, where column A is the Meeting Date (date format), column B is the task (text format), column C is the Lead dropdown (i.e., the name of the Lead person for the task), column D is the Support dropdown (i.e., the name of the Support person for the task), column E is the Status dropdown (i.e., the status of the task), column F and column G are the start and end dates of the task respectively, column H is the Deliverable column (file format), column I is the Email Address column (text format), and column J is the Notes column (text format). I have a formula in column I the Email Address column where when the Lead and/or Support name are selected from the dropdown menu their respective emails will autopopulate into the Email Address column, separated by commas. I want to send a weekly email (at 9am PST) reminder to the emails where the Status is Not Started. I have selected [Email Address] as the value for the To field but the emails don't seem to send. I'm wondering if it's because there is a formula in the Email Address column even though the emails do show. Any help with this would be greatly appreciated. Thank you!
User | Count |
---|---|
17 | |
12 | |
5 | |
5 | |
5 |