Contacts
Discussion List
-
Reference a contact in IF formulaIn Formulas and FunctionsI'm trying to return a value of "TRUE" in a tick box column if a contact referenced in the same row is a specific person. It's a multiple contacts column too but I've done dummy runs with only one contact and it still won't work.…
-
Need help with formula to automatically fill in Contact List from another columnIn Formulas and FunctionsHello, I have the following columns and sheets and I just cannot seem to figure out how to do what I need. Sheet 1 (Main Sheet) Staff Listing (value is Text Full Name coming in from outside source) All Staff (Contact List selector (assigne…
-
@ functionality not showing contactIn Using Smartsheetone of my users has issues when trying to use the @ functionality that sometimes certain users do not show up for her to tag. Other times on the same sheet the person shows up. When I check on my instance the person is always there. Any…Answered - Pending Review 44 views 3 comments 0 points Most recent by Jaykel Torres Using Smartsheet
-
Prevent cells from changing once value is entered?In Using SmartsheetI have a multi-contact column that I'm using to fill in other cells. The problem is, if new names are added or removed it reorders the contact list. So when extracting the name to another column, the name of the person can change which col…Answered - Pending Review 11 views 2 comments 0 points Most recent by Matthew Emrich Using Smartsheet
-
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 1.2K views 22 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Vlookup Contact List... Recognition after SaveIn Formulas and FunctionsI'm using a helper column with Vlookup to populate a email address from a contact list sheet based on the name of the person in an adjacent column. The contact is populated properly when the sheet first opens but then it's like it is not r…Answered - Pending Review 32 views 2 comments 0 points Most recent by Thomas Whiteley Formulas and Functions
-
Alert Someone Automation - Reference Contact In Summary FieldIn Apps, Integrations, and Add OnsWhen configuring an Alert Someone workflow and selecting "send to contacts in a cell", is it possible to reference a contact in a Sheet Summary field for the sheet? The drop down selection only shows contacts columns within the b…Answered - Pending Review 35 views 1 comment 0 points Most recent by Andrée Starå Apps, Integrations, and Add Ons
-
Master Contact List for use across sheets in a workspaceIn Using SmartsheetI have 16 grids that all use a Contact List with 23 of the same client contacts. (1) its a HUGE waste of time to have to populate 23 contacts into a list 16 times and (2) every time a new person joins or leaves the team, I have to go into…
-
Control for Character Entry on FormIn Using SmartsheetHi there - Is there a way to control the characters used for a form? I would like to limit to just roman letters. If this isn't possible, a suggestion for a work around on the grid? ie. We have event rsvp that are entered in Chinese char…
-
Automatically Select Contact With Column FormulaIn Formulas and FunctionsHi, I am fairly new to smartsheet so I apologize if this is a basic question. I am trying to automatically populate a contact column with a single contact indefinitely. For context, it's just so that in a separate report that pulls from ma…Answered - Pending Review 33 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
