-
How would I parse out a contact field with multiple contacts
We have multiple projects, each with their own project plan sheet. On each sheet we have the usual project plan columns, Start Date, End Date, Duration etc. We also have an Assignee (resource) column that is a multiple contact type. This works well on the project plan. However ... We have the same resource on multiple…
-
Set Contact field display type to name or email
When using Assigned To or any other contact field across a large number of sheets, and then aggregating that data in a report or pivot that groups by the contact field, it becomes quickly painful that the same contact appears as both their email address and their name, depending on how someone entered them into the Contact…
-
contact
I started a Smartsheet trial yesterday. What I really need is to be able to SPEAK to someone personally about this application! There is no contact number available for "trial users". One found on Google does not work. And any email (3) that I was able to find was either unmonitored or no longer active! How can a…
-
Index/Match Formula Referencing Contact Columns Providing Wrong Values
I need help with a formula. Since there is no way to cross-check against a group in a sheet, I have created a sheet listing all users of a particular group and am trying to use a cross-sheet reference formula in my intake sheet to be able to identify when a requestor is not already in the group so that I can add them for…
-
Contact list in Smartsheet after importing data
I am running into an issue where I import a group of names assigned to a certain task in Smartsheet. The list of names comes from an excel spreadsheet as multiple agencies must provide their inputs and not all have Smartsheet access (the Smartsheet in question is only for my agency's use). Well after importing the updated…
-
Copy/paste (or otherwise easily convert) contacts from a worksheet column to create a group
There needs to be a workflow that allows a user to select a contacts column and be able to copy/paste (or otherwise transfer) the values into group management. The current settings do not allow one to easily transfer or convert contacts in a worksheet column and into a group because of how the contacts field is formatted.…
-
Is there really no way to copy/paste a contact column to create a contact group?
Hi, I feel like I am eating crazy pills here, but is there really no way to copy contacts in a Smartsheet worksheet contact column into a Smartsheet contact group without jumping through insane workarounds? My contact column must allow for multiple contacts / cell. It uses the company directory, so it doesn't only have…
-
Bulk import contacts from Excel
I downloaded the CSV file from smartsheet with my contacts, I manage to add addiotionals and tried to upload it. It doesn't work. Why? Can I import somehow from excels file saved as CSV?
-
Contact List and Drop down List values can be referred using a reference from a different sheet
For Contact List and Drop-down list columns currently the values need to be added and updated individually in all columns and sheets eventhough the values are common for many columns and sheets. If we have a provision to have the values referred using a reference from a different sheet, then we can add or update the values…
-
Contacts Column Not allowing contact to be selected
I am a admin user and use a sheet to log communications. WE have a Contacts column where the staff member is suppose to select their name, as the person entering the data. However, when 1 particular user tries to enter their name, they receive the error below. The particular person's name has been added as a contact, but…