Is there a work around? Alert or Update Request?

Sinema

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. 

 

 

Paul Newcome

The email address would need to go into a Contact type column. Once you set up your workflow to trigger on the date, you can specify who to send it to by selecting the option of "Contacts in a cell" then selecting the Contact column.