I have a sheet with 12K+ total tasks grouped in identical sequences of 15. I need to globally assign specific tasks in each group to specific contacts. I am aware through research that formulas cannot be used on contact columns. Is there a workaround anyone has discovered? Thanks in advance.
This discussion has been merged.
I'm stuck and I'm hoping that someone can help me out. I'm importing an MS Project XML file into SS and everything works out except for the resource to contact. The "assigned To" field is filled with comma delimited names (name only no email) and I need to find a way to convert that into contacts. I can go line by line…
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
Hello, I am trying to "suggest" a contact in a contact list column but can't find a way to automatically populate a cell while still having the ability to overwrite it later if that suggestion is not correct. So I've got a Program column, a Suggested column, and a Assignee column. Program is a dropdown and Suggested…
Hi, I have been adding team members onto my projects via the "Contact List" in my "Assigned To" column and can see them in my "My Smartsheet contacts". However, I was then reading that I could add unlicensed "Users" via "User Management" and noticed that my Smartsheet contacts aren't there. Do I need to add them to both…
I am using control center to create projects. In the sheet that gets provisioned, I have my resources listed. I want to bring the "Lead" contact back into the Intake sheet, but it is coming back as just text and not an actual Contact. We use the Current User view for project updates, which won't work this way. Any ideas on…
Are Smartsheet contact groups only used for assigning roles/permissions/access within an organization? Could I for example, create a contact group of emails that are outside my organization so that I could easily share a dynamic view with all of them? The underlying sheet would have a contact column and I would restrict…