-
Sharing a Contact List
Good Morning. is there any chance to have a sheet in Smartsheet with a list of contacts and connect that list as Smartsheet contacts to share with all people within your Business account? (10 members with licence in my case) regards
-
Contact column selection - bulk upload
Hi everyone, Wanting to use the contact dropdown option in a column, is there a way to do a bulk upload to this so I don't have to select 100 contacts individually? Thank you!
-
Contact List Functionality in Forms
I've noticed this request a few times over the years, but still don't see that Smartsheet has addressed this. When using sheets, the "Contact List" column works wonderfully and will populate any user within our Smartsheet account when you begin typing a name. However, when attempting to use this within a form, it DOES NOT…
-
Formula Help - Conflict Check Across Multiple Sheets
Greetings! I have been trying to figure out a formula that will solve a problem. I have a column in schedule that I would like to show "Conflict" if the contact@row is scheduled on the current sheet and on a different sheet within the same date range. I have an easy conflict check for whether someone is scheduled on the…
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':…
-
Capturing Contact with email in Forms
I love the fact that a Contact field can contain both the display name and email address in one. For our current project, we don't have a way to collect all of the contact names & email addresses ahead of time, so we are capturing that first entry in a Form (along with other key pieces of information). For a user to…
-
How do I pull the fourth, fifth and sixth name from a multiple-contact column?
In Smartsheet I have a contact column (Project Support) that can have up to six contacts (first name + last name), for example Jane Doe. I then have six other Test/Number columns that pull the first contact, the second contact, the third contact, the fourth contact, the fifth contact and the sixth contact. The first…
-
V Lookup formula for importing Contact List broke and I don't know why.
So I have a reference sheet of contacts and their assignments. I made a different sheet to assign tasks as they come in and set up an equation to look up and auto assign. It looks like: =VLOOKUP([Rule Number]@row, {Committee Range}, 2, false) So when a task came in and it matched the rule, it would assign the person in the…
-
Imported Contacts
I have an excel import that has names of persons. I need a contact list to generate items, dashboards, reports, etc. How can i make the imported column with names a contact list so that when it is updated upon a refresh it will not affect the contact list. or do i need to create a different contact list/column? if so, how…
-
Can I use a Contact column in one sheet to populate options for a Contact field in another sheet?
Hi all! I manage a sheet with a very long list of employees (500+) who have signed up for a program. I'm trying to create another sheet so that the program administrators can easily fill out a form to identify when an employee participates in a development event. I'd like the form to have the contact list from the master…
