-
Pre-Populate a large contacts drop down
Under Contacts List type - where the 'Values (Optional)" is, I have about 574 e-mail addresses to pop in there. I want to restrict the list to a contacts drop down as it will run some automation and also drive the access permissions in Dynamic view. Seems I can only pick a record at a time though, I can't figure the string…
-
How do you represent your team contacts in a dashboard?
Hi There, I would like to add a widgit that shows team members, titles, and contact info but I am unsure how to do this. Is there a way to include contacts in a dashboard pull from Smartsheets?
-
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?
