-
Issue With Smart Sheets Forms Automation, and Data not Being Recorded in the Right Row!
Good day! i'm facing a weird issue with smart sheets automations, I have created a form on smart sheets and the questions were linked to the sheet columns normally i created a column of email contacts list to run the automations over, and the idea was that whoever gets this form link to fill from this email list, will fill…
-
BRIDGE/API: Add Users to Group from Sheet?
Hey Y'all! I'M STUCK on the next step for my Bridge solution. I'm simply trying to add members to a group named "GroupTest" if the [Approval Status] in this sheet (image below) gets marked as "Approved", but only if it's not already in the group. Eventually, I also need to have the status of "REJECT" remove them from the…
-
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':…