I’m setting up a help desk ticketing tracker. The help desk team takes calls from users and captures information in a Smartsheet form, which populates a sheet. The sheet autogenerates a ticket number. I want to automate an email to the caller’s address, which was entered in the form.
I was able to do this by setting up an automation. But the only way I found to make it work was if the caller’s email column in the sheet is a Contact List. I recently learned that the length of the contact list is very limited, and will fill up quickly.
I’m looking for a way to automatically generate an email to the caller once the ticket number has been generated. And send another notification to the caller once the ticket is closed.
Thanks in advance for any help!