-
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":…
-
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…
-
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
-
Merged: Capturing Contact with email in Forms
This discussion has been merged.
-
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…