-
Using a formula to subtract out a Contact
Hello, Is it possible to use a formula that when given a contact cell with multiple assigned contacts, and a secondary cell with one assigned contact, will SUBTRACT that contact from the first cell? So in practice it would look like this: Cell 1: Contact1, Contact2, Contact3 Cell2: Contact2 Cell3: Use a formula that…
-
Populate contact cell with multiple email addresses for alerts?
I have investigated a few possibilities for this without success. Basically, I have a sheet of facilities with facility info. One of the items is what market that facility is in. So, If I want an alert to go to the entire market, I need to collect the email addresses for each facility that is in the market, then my…
-
Assigned to // Contact List
Hi all, I have an equipment tracker sheet that has an Assigned To column set as Contact List. I came to realize that regardless this sheet is not shared with them, they are able to change/edit/modify the cells of this tracker sheet. I don't want anybody to edit those cells except the ones that are already in the shared…
-
Approval Workflow - Request approval from a pre-defined contact in a sheet
I have a use case where the approver for something will not always be the same individual. I would like to add a column for the approver (contacts list), and have an automated approval workflow that sends an approval request to the individual listed in that column. Smartsheet seems to require that I specify a single…
-
How can I notify staff when an assignment in a contact column changes?
I have a sheet set up with a contact column so I can assign staff to a request. This assignment is automatically triggered based on request type. When the staff are assigned to the new row, I set up an automation to notify them via email of the request. This is working well. However, sometimes the assignment is changed…
-
Contact List Column auto-populating with org emails
Hey there - new(ish) to Smartsheet and in a bit of a pickle. I have a sheet with a Contact List column that I use to request updates from outside partners. However, when the update request is sent the Contact List column field (where they could update their contact email) features a drop-down of emails for all users in the…
-
HELP: sending automated notifications to multiple contacts in a cell
Hi Folks Is there a way to send an automated email (via workflow) to multiple comma-separated emails in a cell ? I have tried, but so far have failed. Nothing seems to happen when I trigger the workflow. Any help would be appreciated.
-
Contact Groups and Contact Lists
I have a situation where I need to frequently add approximately 45 people to a contact list. They are often the same 45 people, but there are occasional variances. I know there is a way for the Smartsheet admin to add contact groups, but is there any way a regular licensed user can do this? Our organization has 5,000…
-
Getting a Contact from a form input
I'm implementing a Sheet to receive input for Time Off Requests. For the submission form, the users will enter their name, the names of their approvers (supervisors), and their department's timekeepers. For these 4 employee columns, I have created them as Contact Lists. I have created an approval workflow and also reports…
-
Including CONTACTS in the Excel import
I have a list of records that I need users to review and update, but they only need to see the records assigned to their user account. But as soon as I import the file into Smartsheet, the column of usernames (contacts) is listed as text, not as CONTACTS (Smartsheet users). How can I fix this? I want to use the usernames…
