-
Form has a contact list field, for the contacts are not pulling into the form
Hi, We created a form to take in change request. The sheet has a column 'Interested Party" and this is a contact list. When i am in the sheet, i can start typing a name and the contact list based onthe spell comes up. This does not work the same in the form. Is there a setting that I am missing?
-
Return multiple contacts based on department dropdown list.
Hello, I would like to use a master list with a list of people attached to the department that populates multiple contacts in the same cell depending on what dropdown departments are selected. So Sheet 1: Department Email Marketing Billy@help.com Operations Bob@help.com Sheet 2: Departments (dropdown multi select)…
-
How to display names instead of email + names when making a bar chart with a contacts column?
Hi! I'm trying to make a bar chart that shows # of tasks for each person in the project. I used the contacts column, and it shows as just their names in my sheet, as well as in the report I am pulling this from. But when I put it into a chart, it is so cluttered with their emails, and I just want their names only. How do I…
-
Contact List suggestions not showing on Dynamic View
I have a number of contacts added to our sheet, however, when other people in my team access the sheet via dynamic view they cannot see the contact list suggestions on the dropdown.
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Extracting Email Address From Contact Column
Hello, I have a contact column from which I'm trying to extract the email address. I've seen instances where a helper column is created that is set equal to the primary contact column and the helper column is changed from contact to text. That approach won't work for us because the contact column will have new inputs and…
-
Trying to collect data from a sheet where a person assigned is one of multiple contacts
Hi, I'm trying to revise a formula and am a bit stuck on how to do it. I would like to pull resource utilization information from my Project Plan into a Team sheet (and no, we don't have the Resource Management module or Control Center at my organization). Here is an example of the current formulas I'm working with:…
-
Email Addresses from Contacts
Is there a way to convert / extract the email address from the values in a column set up as a contact? I have a need for the email address associated with contacts. Thanks
-
Best practices for approval process - contact list or no contact list?
Scenario: we are using smartsheets as a single-source tool for job/position requests. Each request submitted creates a row and all information pertaining to that request is held within that row. We need to get approvals from Department Heads for each request submitted. However, we don't necessarily want to create a contact…
-
Dynamic View: Contact List Must be Restricted
Hi All, Is there a reason why the Contact List on the Dynamic View must be restricted from putting names on the dropdown? If it is not restricted, it will only show the Users within your plan. This is counter-intuitive because one of the main purposes of using dynamic view is to share editing permission for external…
