-
Contact List Rollup
I have a multi-select contact list column for assigning tasks to team members. I want the contact(s) assigned in the child row(s) to roll up to a master set of contacts for the parent row(s). However, when I try =JOIN(CHILDREN(),", "), I end up with a list that has blank items separated by columns and duplicated names if…
-
Fillable Drop Down or similar?
Hi There! I am looking to create a smartsheet where staff can input multiple names without having to do multiple forms back to back. For example the question would be: who took the class? and then the staff would input names that would populate onto different lines int he database. Can I do that with drop down? Or contact?…
-
How do I pull the second name from a multiple-contact column?
In Smartsheet I have a contact column (Project Support) that can have up to three contacts (first name + last name), for example Jane Doe. I then have three other columns that pull the first contact, the second contact and the third contact. The first contact column is Project Support 1 and the formula is =LEFT([Project…
-
Combine emails into a multiple-contact column / multi-contact column
Multiple-contact columns can be problematic to use in Smartsheet. Namely, they cannot be "put together" with a formula. There's many use cases where you need to build multiple contacts into a cell based on criteria/lookups, but there isn't a way to do that in native core Smartsheet. There is, however, a couple of methods…
-
Sync User Management list with Smartsheet Contact Lists
It would be extremely helpful to have our users' first and last names and email addresses, as listed in the User Management List in the admin portal, synced with available contacts in the Contacts List to input as a contact in the Contact List column type. People are really confused as to why no names automatically show up…
-
Having trouble populating a contact list column (Auto-provisioning is not enabled)
I understand the ultimate solution if I want all employees in a contact list is to enable auto-provisioning. Our IT department isn't ready to do that yet. In the meantime, I have searched help and the community and can't figure out how to solve the problem. I need the contacts not in "my contact list", I need them as…
-
Managing Contacts
I had a contact that was mispelled. I correct that contact in My Contacts. However, when I add the person to an automation, the incorrect spelling appears. I no longer have the incorrect spelling in my contacts. I went through the whole sheet and removed the mispelled contact. I re-shared the sheet with the Correct…
-
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…
-
compare multi-contacts to a text string
Hi everyone, I am building a schedule for my team that will confirm if a combination of assigned staff 'assigned to' are trained to do a specific task 'task combos'. the 'staff trained in this task' is a text column that is using JOIN(COLLECT) to combine contacts who are trained in a task, these are in different columns…
-
Contact List - Determine if Email Is Missing
Hi! I have people filling out a Smartsheet form who are NOT licensed users and providing email addresses in a Contact List field for NON licensed users. I need to a way to know quickly if someone didn't follow directions and put their name instead of email into the form. I also have data already in the sheet where folks…
