-
Importing email addresses as Contacts
We have an Excel worksheet that contains email addresses and are using Data Shuttle into import them into a worksheet. The email addresses are going into a Contact column. In some of the cases the record will come in with the email address and other cases it converts to the person's name. Is there any way to force it to…
-
Contact List Functionality in Forms
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…
-
Assigned to column with avatar only setting
Hi! The assigned to column works well, and I like seeing everyone's name. However, it would be very helpful to have a "quick indicator" nearer to the project name as to who is assigned this task (or to update the column without scrolling over to the assigned to column). It would be nice to be able to choose an "avatar…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Sharing Contacts
We currently cannot share our contact list with other users. This is very cumbersome for our company. We use Smartsheet to create a punch list for our vendors. We need multiple users from our organization to enter in punch lists for peoples, however, since I cannot share my contact list with my colleagues, we end up having…
-
Bridge: Update a Contact Column Dropdown List?
Has anyone successfully used Bridge to update the dropdown values in a Contact List Column? I'm trying to modify a workflow that updates a Dropdown column - and it seems like it should work, but I keep getting this error (or something similar): I've tried formatting the source column as a Contact Column, a Text Column…
-
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…
-
What licensing is required for collaborators, commenters etc please?
Hi, I have searched but can't find a definitive answer. If I create a project plan in Smartsheet and want people to comment, update or collaborate in general, which of those need a paid license please? To clarify, in this scenario the creator of the plan would have a business license. Many thanks.
-
Choose Display for Contact field
I want to be able to a)choose what info about a user the contact field shows. I'd like to be able to see their department, or title, or email address, etc. And then b) if I'm viewing the contacts' emails, I want to be able to select one or many of them, hit copy, and be able to paste the emails into another app like Gmail…
-
Updating Contacts via M365 / AAD
Hi, Is it possible to link to Microsoft 365, or AAD, and pull through contacts for all users automatically? This way i can type in Jchap and it will come up with my email, or Joe C and it will also populate me for ANY user in the sheet?