Enterprise Plans - Active Directory Integration for Contact Columns
I would like the ability to have the option to add all Smartsheet users in the same plan as dropdown options in a contact column. For enterprise plans using AD, this would create an active staff dropdown column. This would solve many issues and workarounds for HR, IT, and PM functions.
Automations when selecting from contact dropdown
I created an automation to move rows to a specific person when they are selected from a contact drop down. I have more of these to building, with different automations such as copy a row when they are selected from an other drop down. I also need to add a notification when each of these process have run. I attached what I…
Automation workflow assigning people in a Contact List column - list doesn't match
Hi! Did something change related to contact list columns and assigning contacts in automations? I have used automation workflows before with the "Assign People" action and the "Assign people in [contact list column name] and as far as I can remember, it used to give me a list of the contacts entered into that column (in…
Batch Add 100+ Preferred Contacts to a Contact Dropdown
Hi there, I'm attempting to add 100+ free users into a dropdown contact column. I imported the users into my Smartsheet Contacts but my goal is to have that same list present on the specific sheet contact column to avoid audit results being sent to the wrong individual. Is there a better way than adding one at a time?…
Using INDEX/COLLECT to return multiple values
Looking 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 project number from one sheet to another, and is supposed to return ALL of the…
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…
Contact List column updated from Microsoft Dynamics
I am populating a contact list column using the Microsoft Dynamics connector. Even though the contacts are created in the Smartsheet, populating it with the exact name using the connector does not create it as a contact and inserts the name as text. This means that you cannot use this contact list column in any workflows…
Easier way to list everyone in the Contact List in Form (Contact - Multi Select Column type)
Currently I have to list each one of the contact if I want to appear names in the Drop down section in the Form. Otherwise form will not be drop down selection like below and it's blank. I don't want to have to list / chose ALL users constantly especially we have more users every week.
Comment Conversations Inconsistent Contact Dropdowns
Hello! I've experienced this issue for some time, but it's becoming more of an issue with the number of comments we need to add to a particular sheet. When adding Comments/Conversations, I am able to @ tag a user using their email, but also sometimes their name. While I can always use their email, I can often not search by…
How to display the Assignee(Contact) of Successors?
I would like to display the Assignee(Contact field) of Successors. I currently use a Successor formula to successfully reveal which task rows are dependant. How can I also reveal who the next assignee of that task should be?