-
Using IF and OR to Assign a Contact
I am currently using the following: =IF(Line@row = "Apples", {Contact 1}), IF(Line@row = "Oranges", {Contact 2}), IF(Line@row = "Pineapples", {Contact 3}), IF(OR(Line@row = "Red Grapes", Line@row = "Blue Grapes", Line@row = "Purple Grapes", Line@row = "Green Grapes"), {Contact 4}), IF(OR(Line@row = "Pears", Line@row =…
-
Restrict a Contact list to a single sheet
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 restricted list of contacts only available to those who can view the sheet. Is this possible…
-
Editor Permissions
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 users and and not to allow them delete the rows and columns ? Thank you
-
Limit Proof Request List
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. Thanks, -Luke
-
Validate an email address in a contact list
Hello, We have a situation where we have two employees with the same name, "Test User", and they have the following email addresses: test.user@smartsheet.com test.user2@smartsheet.com (Please notice the "2" in this email.) We use a form to populate our sheet and the form user is required to type(paste) the email address…
-
Current user + formula in Contact List?
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 Current User filter, nothing shows! I can only assume that using a formula to fill a…
-
Calculation of the number of actions per contact for a multi-contact cell
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 year 2020: How many times was the contact "e-mail address" mentioned? -->…
-
Lookup contact name from email address
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. I'm aware that I could achieve something similar by have a second sheet with Names and email…
-
What does the circle with the contact's initials mean?
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?
-
Contact list format
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 and some don't. After some thinking, it appears that if the names have a comma in them (i.e.…
