Contacts
Discussion List
-
Dashboard - Embedding links to email addressesIn Using SmartsheetI've seen some past posts on this topic but have not gotten the workaround to work and was hoping that there may be progress on a solution. At the 2020 Engage event, I saw a beautiful dashboard that had images and email links under a title…
-
Adding contact group to drop down menuIn Using SmartsheetIs there a way to add a contact group to the dropdown list in a contact list column?
-
What is the difference between "My Smartsheet Contacts" and unlicensed users on "User Management"?In Using SmartsheetHi, I have been adding team members onto my projects via the "Contact List" in my "Assigned To" column and can see them in my "My Smartsheet contacts". However, I was then reading that I could add unlicensed &…
-
How many rows a contact is entered in a sheet?In Using SmartsheetHello! I am trying to count how many rows a contact is entered in a sheet. Do I create a summary field? I am using this formula for my text/number summary fields to count each status (for a report that I am using in a dashboard): =COUN…
-
Client name incorrect in Contact List background and will not changeIn Using SmartsheetI inherited the Smartsheets/workbooks a couple of years ago, and I recently noticed (on an update workflow request I just created) that a client's name is incorrect. I can not change it. Any ideas where this name is stuck or how I correc…
-
IF statement to Output Column Contact List NameIn Formulas and FunctionsHello! I feel like this is a fairly easy formula, but having issues populating the ACTUAL contact name vs. the TEXT value using an IF statement. Goal: In this example, when I change the status to phase 1, I would like the Current Assignee…
-
Pre-Populate a large contacts drop downIn Formulas and FunctionsUnder 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 …Answered - Pending Review 21 views 2 comments 0 points Most recent by colemant Formulas and Functions
-
How do you represent your team contacts in a dashboard?In Formulas and FunctionsHi 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?Answered - Pending Review 36 views 1 comment 0 points Most recent by Heather Duff Formulas and Functions
-
Create multi-contact cell from a row array of individual contactsIn Formulas and FunctionsI have a sheet as: Header: SME1; SME2; SME3; All SMEs Row 1: Bill Ross; Suzie Collins; Anne Doe; =join([SME1:SME3]@row) Each of the SME columns is a contact. I want to fill my 'All SMEs' column with a formula which makes a multi-contact w…Answered - Pending Review 11 views 2 comments 0 points Most recent by Jonathan Valz Formulas and Functions
