Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Using Contact List Column Type in Task List Forms
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.