Contacts
Discussion List
-
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 23 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.
-
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…
-
Index Match or Index Collect with multiple criteriaIn Formulas and FunctionsI'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row,…Answered - Pending Review 232 views 13 comments 0 points Most recent by JamieLim Formulas and Functions
-
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…
-
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?
-
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] = &…
-
Copying contact information from one sheet to anotherIn Using SmartsheetIf my users attempt to copy contacts from one sheet to another, they loose the total contact information. Only the name, as text comes over. Even if both column types are Contact. There does not seem to be an easy way to copy over a list …
-
Contact List Field in the New Logical FormsIn Using SmartsheetI have a grid with a Contact List Column and I have imported all of my contacts from Outlook, in the grid the field will start suggesting contacts as I type. I created a form from the grid but when I launch the form and start typing in the…Answered - Pending Review 82 views 7 comments 0 points Most recent by Caitlin Smith Using Smartsheet