Contacts
Discussion List
-
Adding names to Contact List DropdownsIn Using SmartsheetCan 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?
-
Get a list value from another sheetIn Formulas and FunctionsHi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? Thanks
-
Contacts in a FormIn Using SmartsheetHi 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 lawy…
-
How can I set a contact list column to display only the email and not the contact's name?In Formulas and FunctionsI 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 col…
-
Contact List formatting from formula only showing email addressIn Using SmartsheetI'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([email protected] = "Eric R.", "eruss…
-
Inconsistent results when using contact list columnsIn API & DevelopersI 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 con…Answered - Pending Review 41 views 2 comments 0 points Most recent by Andrew Finkernagel API & Developers
-
Contracts, Purchase Orders, or Change Order ManagementIn Using SmartsheetIs anyone using Smartsheet to handle contracts, purchase orders, or change orders? I'd love to see how you manage them with Smartsheet.
-
Assigning Multiple ResourcesIn Using SmartsheetI've seen posts going back 3 years that address this subject, and it's little mind blowing that a feature as basic and essential as this does not seem to be possible yet. My team works on multiple projects each day, and each project has at…
-
Change contact on update request emailsIn Formulas and FunctionsI 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?Accepted Answer 11 views 1 comment 0 points Most recent by Tamara Gordon Berlik Formulas and Functions
-
Using IF and OR to Assign a ContactIn Using SmartsheetI am currently using the following: =IF([email protected] = "Apples", {Contact 1}), IF([email protected] = "Oranges", {Contact 2}), IF([email protected] = "Pineapples", {Contact 3}), IF(OR([email protected] = "Red Grapes", [email protected] = &…
