We're looking to use a Smartsheet form instead of a hard-coded form on website. Currently with that system, someone fills out the form, we get an email and can then respond accordingly (if they've selected us to do so), all the while transferring the data from the email to our tracking sheet.
What we'd like to do is use Smartsheet for the web form, and have the email that is generated when someone ticks the box 'send me a copy of my responses' also to be sent to ourselves, so if someone has requested contact, it's an easier way for us to contact the person with a response/more details, etc. and all the while not having to copy and paste data into a sheet (it's already been done via the form).
I've tried workflows but it triggers for the whole sheet, and as there may be multiple forms submitted at once, I can't select a row number as I've no idea what it'd be. I've also tried to have my own email as a contact 'hidden' in the form but that just shows up in the sheet - no email is generated.
I've looked a bit on here for similar requests but haven't found one that would fit - so any help greatly appreciated!