-
Manage contacts in the Smartsheet Contacts list Company Wide
Hi, is there a way that we can create contact list groups for all users that automatically show in the users contact list?
-
Adding Contacts To Contact Columns
In an individual SmartSheet that I'm setting the "Column Type" as a "Contact List", is there a way to add all of my SmartSheet contracts to that drop-down list without individually select folks one at a time? Same goes for "sharing". I want to share sheets with my whole operation (75+ people), but having to individually…
-
Sending Alert Email based on Contact Column without sharing sheet
I would like to create an Automation to send an email regularly to recipients that are in a Contact column based on some criteria. After setting up the Alert Email it says that I must share the sheet with these people in order for them to receive it. The email contains no information from the sheet other than getting their…
-
How to create a contact group
Dear community, kindly seeking for your help to find the way how to create a group of contacts (or a way to add a pre-created User Group) in a drop down list in "Send update request" function during "select contact" drop down list. Hope my question is clear as english is not my native language.
-
Merged: Dynamic Contact lists - User groups to populate dropdown and/or forms to reference user lib…
This discussion has been merged.
-
Return multiple contacts based on department dropdown list.
Hello, I would like to use a master list with a list of people attached to the department that populates multiple contacts in the same cell depending on what dropdown departments are selected. So Sheet 1: Department Email Marketing Billy@help.com Operations Bob@help.com Sheet 2: Departments (dropdown multi select)…
-
How to display names instead of email + names when making a bar chart with a contacts column?
Hi! I'm trying to make a bar chart that shows # of tasks for each person in the project. I used the contacts column, and it shows as just their names in my sheet, as well as in the report I am pulling this from. But when I put it into a chart, it is so cluttered with their emails, and I just want their names only. How do I…
-
Contact List suggestions not showing on Dynamic View
I have a number of contacts added to our sheet, however, when other people in my team access the sheet via dynamic view they cannot see the contact list suggestions on the dropdown.
-
Extracting Email Address From Contact Column
Hello, I have a contact column from which I'm trying to extract the email address. I've seen instances where a helper column is created that is set equal to the primary contact column and the helper column is changed from contact to text. That approach won't work for us because the contact column will have new inputs and…
-
Trying to collect data from a sheet where a person assigned is one of multiple contacts
Hi, I'm trying to revise a formula and am a bit stuck on how to do it. I would like to pull resource utilization information from my Project Plan into a Team sheet (and no, we don't have the Resource Management module or Control Center at my organization). Here is an example of the current formulas I'm working with:…