-
Request to Filter Deactivated Users from Contact List Columns
Currently when a column is setup to follow the "Contact List" functionality, the list of users it offers as selections includes users that have been marked as deactivated. Could Smartsheets instead exclude these users from the listing to ensure Project Managers don't accidentally assign task rows to users who are no longer…
-
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!
-
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…
-
Merged: Capturing Contact with email in Forms
This discussion has been merged.
-
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…
-
Mapping Azure AD Groups to Contact Groups with SCIM
I must dynamically provision contact group memberships from dynamic groups in Azure AD based on departments or projects. I usually use SCIM to map AAD groups to application groups in other enterprise applications. I don't see this ability in Smartsheet and would like to request this as a new feature. I would also be happy…