Currently, the Calendar App only recognizes a contact list in the Task Owner field if the contact column is single-select. If the column is multi-select, the app returns an error when trying to enter information in this field from the "New Item" function and does not let you edit if there are already contacts in the field.…
Hello! Has anyone figured out a way to load a column of emails or names, any combination really, into a contact column on a sheet where the user's first and last name appears rather than just the user's email? We're working on a large list that will be a source table for numerous systems and I want to user's contact to…
I have over 5000 rows in a sheet that has been exported from ServiceNow. Every row has a contact cell that is filled out with a raw name, no company email. Is there a way of converting every cell into the respective company email for that person at once? The manual method, typing their name and selecting the pop up, will…
Currently there is a limit of 20 contacts within the Contact List column, which is not sufficient for our needs. It would be great to either increase the maximum to a significantly higher number, or removing the limit whatsoever.
I can see it's not possible to import the contacts to Smartsheet using the CSV file. I exported all the employees of my company to CSV file and cut it into pieces so each has less than 1000 records. However when I try to import it to my contacts in Smartsheet - nothing happens - no error window. Can you help?
We discovered somewhat alarmingly that the Modified By column does not record the email address of a person making an approval but rather pulls information from the cell in the approver column. Here is the use case: An approval request email is sent to Person A, who forwards the email to Person B. Person B approves the…
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…