-
Adding names to Contact List Dropdowns
Can I add hundreds of names to a drop down contact list relatively quickly? I have to add ~1000 contacts to my drop down and the thought of entering them one by one is daunting. Is there a faster way?
-
Contacts in a Form
Hi I'm working on a submission form but, I'm struggling with the contact columns. The use case is that a file review will be done on any one of over a 1,000 lawyers the compliance officer completing the file review needs to enter the lawyer and their supervisors name in the form so, that reminders can be sent to complete…
-
How can I set a contact list column to display only the email and not the contact's name?
I often have to use lookup formulas between sheets where one sheet is a system export of information loaded into Smartsheet. The system obviously generates an email displaying as text. In a prior support call I was told to convert the column to a contact list and that has served me well. I've created a Message Tool for…
-
Contact List formatting from formula only showing email address
I've got a formula that pulls contacts from another reference sheet into a Contact List column, but it also checks an adjacent column for a value to transpose a would-be contact: =IFERROR(IF(Resource@row = "Eric R.", "erussell@email.com", INDEX(COLLECT({IT Requisition Tasks Resource}, {IT Requisition Tasks Task Name},…
-
Inconsistent results when using contact list columns
I am attempting to use the API to perform CRUD actions on a sheet. Several of the columns have Contact/Multi-Contact datatypes. I have discerned through practice that when I create or update a row, that the API expects the email of the contact to be provided in the request. Question number 1: Is that actually the case? I…
-
Contracts, Purchase Orders, or Change Order Management
Is anyone using Smartsheet to handle contracts, purchase orders, or change orders? I'd love to see how you manage them with Smartsheet.
-
Change contact on update request emails
I have built update requests through the automation tool, but now to deploy the solution, I want to have the automated emails come from another user. Is there a way to change the contact?
-
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…