-
Contact List - Extract First / Last Name?
Is it possible to target the first or last name of a contact inside an alert email? So e.g. if I have a contact called "John Doe" in a [Contact] column, and I send an alert with Dear {{Contact}} I will get the full name. Is there a way to only get the first name?
-
Contact List not Populating
Hello, I have created a form with a couple of fields that have the Field Type set to contact list, but when testing the form nothing populates in the field, it's as if it was set to text / number. Is there a way to have it auto populate as a user begins to type a name? Thank you.
-
Problem with automation from a contact list
Hello, I'm having an issue importing email addresses from dataShuttle to a contact list, and using automation from this column. When I set up the automation triggers, it won't send to the emails in the contact list column, because it is saying it is a comment and there is an @email@org.com (just general example of what the…
-
Request to Filter Deactivated Users from Contact List Columns
Currently when a column is setup to follow the "Contact List" functionality, the list of users it offers as selections includes users that have been marked as deactivated. Could Smartsheets instead exclude these users from the listing to ensure Project Managers don't accidentally assign task rows to users who are no longer…
-
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…
-
Ability to delete Contact for All Users as an Admin
I want to remove a contact with for all users & all sheets in Smartsheet. It would be really nice to have a contact list in the Admin Center for the Admin to manage the Contacts in Smartsheet.
-
Are you able to pull emails from a Contact column?
I have a few sheets where I am needing to have the data Presented with the individuals name, then the email address in the column next to it. I have come across a few articles that have suggested having a helper 'Contacts Sheet' to reference w/ =INDEX({Contacts Sheet Email}, MATCH{Name@row, {Contacts Sheet Name}, 0)) for…
-
Option to hide profile images in contact columns
I find that some of my sheets get way to colorful and busy when I'm using a contact column with multiple contacts in each cell. It would be great to have a per-sheet option to hide/show the profile images next to contact names in the column.
-
Contact pictures in reports
Is there a way to show the small pictures besides contact names in a "contact list" column type on a report? The small pictures do show up in the grid driving the report, but don't show on the report itself (...and obviously, don't show in dashboards using that report either).
-
Contacts not coming over on all sheets
Hello, we are having issues where the contacts are being saved in the contacts folder but are not showing up on the sheet or cannot tag them in conversation box. Please see examples . I think i have 2 different issues: one where we cannot see the contact as "ALL" on one sheet but can on another. also issue of not being…