Is there a work around? Alert or Update Request?
I'll keep this simple.
In the method I'm using the form every person that uses the form is not required to make a Smartsheet account. They have too many logins and adding another "software" to the mix is not going to go over well; however, they are fine using the form.
This means I'm not able to take advantage of the modified by or created by fields.
I do have them selecting their name in a drop down for a Submitted By field and I have a VLOOKUP populating a Follow Up Email cell; however, I just cannot figure out how to use the email address in an automation.
I want to have a working automation off the follow up date logic that emails the csr when the follow up date is met, but I can not find a way to do this.