I made a recurring task list based on the template Smartsheet provides. I have tasks assigned to different contacts in a contact list column, and users enter new tasks through a webform. My issue comes when they enter the "Assigned To" name. Even if they type their name EXACTLY how it is on their account and in the current contact list, the new entry in the sheet doesn't have their email attached to it - I have to go in and edit it to make sure the email is connected.
I do this so that I can have reminders go out to just the person who is assigned to the task based on the due date. Since you can't use formulas with Contact lists, I can't just use a drop down list for the form and have a formula interpret it into an appropriate Contact.
Any ideas?