Is there a work around? Alert or Update Request?

edited 12/09/19 in Smartsheet Basics

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.

Any suggestions?

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.