-
How to extract email address from a contact list the use the value in an adjacent column
Up until now, I have copied/pasted the email address manually. Nevertheless, our database has grown so much. I've tried the below formula: =IFERROR(SUBSTITUTE(SUBSTITUTE(MID([🎓 Student]@row, FIND("<", [🎓 Student]@row) + 1, FIND(">", [🎓 Student]@row) - FIND("<", [🎓 Student]@row) - 1), "<", ""), ">", ""), "") but after…
-
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 add contacts in bulk in Contact List - Restrict list to values only
Hi there, I'm working on building a request form for my team. I'd like to add all 85 members as contacts in the Contact List field, and Restrict to list values only. How can do this in bulk without having to manually type out/select each name in the Add contacts lookup? Help?!
-
Preserve Email Format When PopulatingMulti-Contact Columns
Description: In Smartsheet, when a Contact column (that allows multiple contacts per cell) is populated using a cell reference containing an email address, the value displayed in the target cell is automatically converted into a display name. Problem: This behavior causes a disparity between the input and output data when…
-
How to convert multiple TEXT names or emails into multiple contacts using Bridge
There currently isn't a way to use a formula to bring together and output multiple contacts into one cell, the values will appear as Text values. (SS Enhancement request submitted). However, I was told there is a way to use Bridge to convert the combined multiple contacts from TEXT to contacts. Please show me the solution.…
-
Pivot App is not recognizing the Contact Columns
We had a lot of pivot tables built from Contact columns but all were showing blank now, when I test manually by creating a new pivots I see contacts columns were not recognizing in the pivot apps, all summaries were grouped under the Blank row. Here is my example eCOA Implementation PM is a contact column and have lot of…
-
Contact Field in Index Match Returning Strange Values
I have a project plan template that is created through the control center. The owner of certain tasks is dependent on what department the project is in. I have a background sheet that is a task owner crosswalk, and then on the project plan it will run an index / match to pull the correct owner. This has been working fine…
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
Smartsheet Salesforce Integration: "Value is not supported for this column Type."
I have created Workflow for bi-directional sync in the Smartsheet Salesforce Connector between Salesforce and Smartsheet. In Salesforce, I have a Lookup(User) field named "Assigned To" and in Smartsheet, I have a corresponding "Assignee" column with the Multi-Select Contact List data type. When I update the "Assignee"…
-
How to Edit Email of a Manually Added Contact in "Assigned To" Contact List Column?
Hi All, I’m a System Admin in our Smartsheet environment. We have a sheet with an "Assigned To" column, which is set up as a Contact List column. All contacts listed in this column are Smartsheet users from our organization except one — this particular contact seems to have been manually added by another user (not from our…