-
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…
-
Dynamic View Restrict by User and Sharing email domains
I set up a form for staff to submit Feedback for PD. I have a contact column for Facilitators. It is not Restricted by List Values Only I need to keep it open so that the end users can add new facilitator emails. I have a Dynamic View for the Facilitators to view their feed back. The DV is Restricted by Current User,…
-
Limit to number of email addresses added to a sheet for automations
Hello, Can anyone confirm if there is a maximum number of email addresses that can be added as contacts to a particular sheet using automations? I believe that number is 101 addresses. My sheet features multiple approval workflows. Each workflow can have multiple approvers, for which column formulas are used to AND each…
-
Contact Groups for everyone
Luckily, I am a system admin and I can add, remove people from groups, but if anyone needs someone added to a group, they have to wait on me to do it. It would be great for others to be able to use groups for the org (created by an admin) or to be able to create their own groups to use within their team.
-
Unable to remove user available in a SmartSheed Contacts list
I created a Contacts list column that additionally had 4 people including myself. I then created a record as an example, using my name. Subsequently I deleted my name from the list and changed it to only allow the available people in the list to be selected. Now I do not show up in the column properties list but still show…
-
Automation adding contacts to a sheet from another (not dropdown)
For each project, we have a 'team list' sheet that shows up on the project dashboard. The team list uses cell links from our master employee list, so by entering the name, it automatically shows their phone number, department, etc. In theory, it should be updated at project kickoff and periodically throughout. It never…
-
Edit Recurring/Scheduled Emails
Hello, We have a number of emails that go out on a recurring basis to specific individuals. I'm talking about the ones you can set up when you click "Send as Attachment" and where you can click "schedule" to set up what days/times the email goes out and to who. We are able to click "Edit Recurrence" but that only allows us…
-
Multi Contact Column with Automations
Hi all, I have a multi choice contact column that has a simple formula that looks at a country column and based on the country returns multiple emails per country, so lets say that column country is France i have the contact column return three contacts, so far it's fine but it doesn't work when i try to use an automation…
-
Deactivate the Share function of AI recommended persons
When sharing a workspace or individual asset, there is a new feature where AI recommends people underneath the box "Invite People and Groups". Is it just our company, or is it 99.9% WRONG in your environment, too? We have over 12k users, and the AI recommendations are an annoying distraction, especially because they are…
-
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…
-
Contact Name Displaying as Email
Ok so.... We have a Smartsheet form that we use to stand up project files in Control Center. When we ask for Contact information it's set up with email validation. Our PMs have said they do not like that that it doesn't say the contact name. For example instead of "John Smith", it displays "john.smith@abc.com". Is there a…
-
CountIFS contact is in a contact list
=COUNTIFS({TEST Range 1}, ="*Name*", {TEST Range 6}, ="DO") Hi all, this is a helper sheet used to get the counts of different conditions. Test Range 1 is a contact list that can contain multiple contacts, how can i make it so that i can check if "Name" is in the list. It is currently returning 0 when it should be finding…
-
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…
-
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":…
-
Pulling a List of Names to a Preferred Contact List
I need to maintain hundreds of log sheets. On the sheet, we use a Contact List column with a preferred contact list. On the form, we use radio buttons to easily select from the list. While this system works well, I've come across a limitation: when we have personnel changes, I need to change the preferred contact list on…
-
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…
-
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 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?!
-
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…
-
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…