-
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.…
-
Formula to populate multiple contacts into a cell based on role
I used the following Match/Index formula to populate the "Assigned To" column of my sheet based on the "Role" column. I have a look up table at the top of my sheet. =IFERROR(INDEX([Assigned To]$6:[Assigned To]$20, MATCH(Role@row, Role$6:Role$20, 0)), "Needs Role") There are many tasks on my sheet which are assigned…
-
Sending Alerts to Contacts w/o Sharing
I have a sheet with information that is not confidential yet isn't information I want to share with all vendors. The managers who can view the sheet already need to see all of the information currently in the sheet. (As the owner, I have other information in columns hidden from other's views ) I set up alerts to go to…
-
Automated Alerts and Actions - customize "From" in email?
When we have automated alerts and actions based on triggers the email displays from: Smartsheet Alerts & Actions (automation@smartsheet.com). Is it possible to customize this? When I manually send an update request the email display shows as my name via Smartsheet - this is better. Ideally for the automated alerts we'd…