Contacts
Discussion List
-
Getting a Contact from a form inputIn Using SmartsheetI'm implementing a Sheet to receive input for Time Off Requests. For the submission form, the users will enter their name, the names of their approvers (supervisors), and their department's timekeepers. For these 4 employee columns, I hav…
-
What does the circle with the contact's initials mean?In Using SmartsheetSome of the names of staff members on my dashboard have a coloured circle next to them with their initials and others don't. I can't work out why?
-
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 41 views 10 comments 0 points Most recent by Shelby Formulas and Functions
-
How do I share a dashboard with a large group of people?In Using SmartsheetI have created a dashboard that I want to share with our entire corporation. Is there a way in the share setting that I can grant view access to everyone that has a @XXXXX.com behind there email address that doesn't require me to add them …
-
Using INDEX/COLLECT to return multiple valuesIn Formulas and FunctionsLooking for the proper way to return multiple values using INDEX/COLLECT. I'm assuming JOIN needs to be in there but can't get it to work! Both without and with JOIN, the formula still produces the first value only. This formula matches a …
-
Contact list in formsIn Using SmartsheetMy sheet has an "assigned to" column, but I am wanting to reference my contact list for the available options. I know when I am directly editing the sheet, I can begin typing the contact name/email address and will see a list of…
-
Formula to combine Name and email to create a contact rowIn Formulas and FunctionsHello, I have a very long smartsheet list of names and emails in seperate columns. I want to join them to create a new column that turns them into a contact without having to fill out the contact card for each person. I tried =Join({na…Answered - Pending Review 150 views 4 comments 0 points Most recent by Stefano Ferretti Formulas and Functions
-
Contact list formatIn Formulas and FunctionsI'm trying to use the text contact list for something, but when I ask it to convert the contact list cell to text and put it in the next cell so I can use it, it is very random in how it "translates" the list - some have quotes a…
-
Formula to populate multiple contacts into a cell based on roleIn Formulas and FunctionsI used the following Match/Index formula to populate the "Assigned To" column of my sheet based on the "Role" column. I have a look up table at the top of my sheet. =IFERROR(INDEX([Assigned To]$6:[Assigned To]$20, MAT…
-
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…
