-
How do I fix contact names not appearing in the cells of a sheet?
When selecting a contact from the dropdown list in a 'Contact list' type column (used to assign leads for tasks), only the email address appears in the cell when a contact is selected, but in the address book the name + surname and email address is listed for each person. How can this be fixed? Thanks
-
Help Article updates January 2026
Hello Community, We’ve published new videos on these topics: Smartsheet contacts in Manage contacts in the My Smartsheet Contacts list Brandfolder user permissions in User permissions How to use Brandfolder asset automations in Brandfolder asset automation How to use Data Shuttle to upload data in Create an upload workflow…
-
Dynamic contact list using reference sheets and Data Shuttle
I have several sheets (>20) that utilize a contact field for which I need to update the options whenever there are changes to our roster. I have difficult contact fields depending on someone's role in the department. My solution, based on suggestions here, is using a regular dropdown as my "contact" field that users…
-
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…
-
Syntax: Add Row via API for Multi Select Contact Column, MULTI_CONTACT
Dropping this here in the hopes Google picks it up for future developers. At times when you cannot use the SDKs for adding rows via the API with multi-select contact columns (i.e. Bridge), the following body payload syntax is correct for posting new rows to a sheet. [ { "cells": [ { "columnId": 4532552246972292, "value":…
-
How to find a missing contact
I have a multi-contact column where I assign users to a task [Assigned To]. I have another column where one of the assigned users selects their contact once they have completed their portion of the task [Completed By]. I want an automation that sends a reminder/Update request to Assigned Users that have not Completed their…
-
Card/Board view not showing Assigned To column as an option
Card/Board view doesn't show Assigned To column as an option for grouping items. Some possible causes that I've already checked: There are no rows that are empty in the Assigned To column Rows with multiple assignees have also been converted to one assignee only The Assigned To column is of the Contact type The assignees…
-
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…
-
Contact List matching
Hi, I have been struggling for awhile that the contact list in a sheet, including automation, doesn't sync with My Smartsheet Contact list…how do I edit the contact list in a sheet? TY
-
Contact Datatype - Data Shuttle Import Function - Column Property Toggle Question
Hello, I have seen a few posts that have a manual workaround for this problem, but they are all a few years old, so I thought it best to start a new thread. I use data shuttle to import (First Name, Last Name, Email Address) to a sheet I can create a new column "Contact" using the Contact Datatype I can populate "Contact…