-
Populating Contact List Dropdown Automatically
We have one sheet where we would like to populate a contact list drop down automatically when they are added to the everyone group. We would want the first and last name and their email. I know this has been discussed many time but still not available. Has anyone been able to make this work somehow without involving a…
-
Split contacts to multiple columns.
In my sheet, I have multiple contacts in one cell. I would like to AUTOMATICALLY spread these contacts across multiple columns in the same row, so that each column has one single contact. The reason I want this is to send approval requests to each contact. (Currently, I can only send approval requests to all the approvers…
-
Extracting Email Address From Contact Column
Hello, I have a contact column from which I'm trying to extract the email address. I've seen instances where a helper column is created that is set equal to the primary contact column and the helper column is changed from contact to text. That approach won't work for us because the contact column will have new inputs and…
-
How to Display Contact Names in Dynamic View Export
I created a dynamic view that includes a Contact List column. When anyone exports the dynamic view, the contacts from the Contact List column appear as email addresses, not names. Is there any way to export the contact names, not the email addresses?
-
Copying and Pasting Contacts From Outlook
Smartsheet should implement the ability to copy and paste contacts directly from the "To" or "Required" fields within Outlook. If the system already has the contact listed it can match them to that existing entry. However, if the contact is new it should automatically use the information copied to create an entry. When…
-
Notification trigger based on email, NOT display name spelling
This could probably have a better title. Here is the issue. We have an API that updates rows to sync with our accounting system. One of the fields is a contact field. It pulls an email from the accounting database. So if Bob Builder the contact, it will put in bbuilder@email.com. Even if Bob is in our enterprise contact…
-
Increase the limit within Contact List column
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.
-
Get a list value from another sheet
Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
API replacing name with email in contact column
Our API had been working fine for over 2 years. It adds/updates financial data rows, including the managers name. When it adds a new row, the manager comes in as an email. (It's in email format from the financial database, so that is what is posted to the cell). But I have a report ready to assist with cleaning that up and…
