Contacts

Discussion List

  • Restrict a Contact list to a single sheet
    In Using Smartsheet
    My use case is with collaboration with external companies. Currently, Columns listed for Contact List are auto-resolving and showing internal contacts and other external contacts. I'd like to either disable auto-resolve or create a restric…
    Answered - Pending Review
    101 1
    Answered - Pending Review 101 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Editor Permissions
    In Using Smartsheet
    Hi, We have sensitive data and its important for us the shared Editor to be able to edit cells information but not to be permitted to delete rows and columns . Is there a way to configure sheet sharing permissions for editors and public…
    Answered - Pending Review
    276 6
    Answered - Pending Review 276 views 6 comments Most recent by Andrée Starå Using Smartsheet
  • Limit Proof Request List
    In Using Smartsheet
    Is there a way to reduce the 1700 smartsheet users under my "Request Feedback" list under proof reviews? I'd like to make the list limited to the 9 people authorized to make revisions so others aren't selected/tagged by mistake. …
    Answered - Pending Review
    47 1
    Answered - Pending Review 47 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Validate an email address in a contact list
    In Formulas and Functions
    Hello, We have a situation where we have two employees with the same name, "Test User", and they have the following email addresses: [email protected] [email protected] (Please notice the "2" in this em…
    Answered - Pending Review
    266 6
    Answered - Pending Review 266 views 6 comments Most recent by TravisK Formulas and Functions
  • Current user + formula in Contact List?
    In Formulas and Functions
    I'm trying to auto-assign an owner to a task based on the task type: The Owner column is a Contact List Column and the email addresses specified in the formula are associated with current user accounts (one being myself). But when I use a …
    Accepted
    1110 11
    Accepted Answer 1.1K views 11 comments Most recent by kenny foo Formulas and Functions
  • Calculation of the number of actions per contact for a multi-contact cell
    In Using Smartsheet
    Hello, I am new to using Smartsheet and I want to extract the number of cells that refer to a contact. This may seem simple, but Smartsheet only takes into account the first contact mentioned in a cell, if it has several. Example for the y…
    Answered - Pending Review
    11 3
    Answered - Pending Review 11 views 3 comments Most recent by Christophe AUBRIOT Using Smartsheet
  • Lookup contact name from email address
    In Formulas and Functions
    Hi, Users enter data into a sheet via a Form. One of the columns is a "Created By" system column. This provides me with the email address. Is there a function to lookup the name from the contact list based on the email address. …
    Answered - Pending Review
    194 2
    Answered - Pending Review 194 views 2 comments Most recent by Michael Halhead Formulas and Functions
  • What does the circle with the contact's initials mean?
    In Using Smartsheet
    Some of the names of staff members on my dashboard have a coloured circle next to them with their initials and others don't. I can't work out why?
    Accepted
    1023 3
    Accepted Answer 1K views 3 comments Most recent by Genevieve P. Using Smartsheet
  • How do I share a dashboard with a large group of people?
    In Using Smartsheet
    I have created a dashboard that I want to share with our entire corporation. Is there a way in the share setting that I can grant view access to everyone that has a @XXXXX.com behind there email address that doesn't require me to add them …
    Answered - Pending Review
    17 1
    Answered - Pending Review 17 views 1 comment Most recent by Bee Ng Using Smartsheet
  • Contact list format
    In Formulas and Functions
    I'm trying to use the text contact list for something, but when I ask it to convert the contact list cell to text and put it in the next cell so I can use it, it is very random in how it "translates" the list - some have quotes a…
    Accepted
    117 4
    Accepted Answer 117 views 4 comments Most recent by Sean Morgan Formulas and Functions