Combine Contacts from multiple columns into a single cell

Hope to have this feature soon. Combining contact 2 or more columns in to one multiple contact column. Would be very helpful. Thank you.

I am using a contact list column with multiple contacts that is created with a JOIN(COLLECT) formula from a Contact List column... The result of the formula is a text list and not a Contact List.

Since I am using this resource to display a dashboard using the "Current User" filter it will only work if I change the column type to text, save, back to contact list, save an then refresh the dashboard and works. But the minute the sheet is refreshed it turns back to text.

Back in November 2021 @Ben Goldblatt referred to this behavior as a reported bug.

I think this will be not only useful but ir make sence that those functions behave returning the data type of the search column itself.

Look forward to your answer...

There are SO many cases in recent years where I've needed to combine people by formula into a contacts column so that a) workflows can be sent to those in that column; and b) Current User can be filtered to enable people in that column to see only what they should be privy to.

I have struggled with the disappearing multi-contact bubbles over and over again, needing instead to create separate columns for each possible combination of users who should receive workflow messaging or access rows that involve them—and not other rows.

Another kluge solution has been to create Groups for each combination, but that's very high maintenance and highly error-prone

Dashboards, Reports, Workflows, Dynamic Views and WorkApps would all benefit from enabling formula-based multi-contact access to specific rows.

Cases in point:

• Sheet A contains a changing list of people on a committee, and related Sheet B needs to send alerts under certain conditions to the people on that list. Currently I have to dedicate a column in Sheet B to each possible committee member because, although by formula I can bring them into a single column from Sheet A to Sheet B, Smartsheet fails to recognize the result (past a single Save action) as a set of multi-selected Contacts.
• Sheet C contains a list of contractors who may be assigned a role related to one or more project rows in Sheet D. I'm unable—without extraordinary gyrations, presently involving manually managing a separate Group for each damn project, and building complex cross-sheet formulas to identify cases where someone has been added to the privy list and needs to be updated to the Group—to ensure that each contractor on Sheet C can see only their rows on Sheet D, and the Gantt timelines for projects they're assigned to in Sheet E.
• Sheet F contains a list with a single contact per row. I would be able to store the contacts for each entity in Sheet G if I could by formula bring all of them back to Sheet F for workflows on the latter. The only other option is to create a separate full set of contact columns for each additional contact, which is variable per entity, so I can't know whether to create a second AND a third AND a fourth ... set of columns because each entity should ideally be able to designate x contacts. Doing that (especially since we can't group columns like we can rows) would then make a really wide sheet to scroll across (first/last/full/email/phone/street/city/stat/zip = 9 columns for each potential additional contact for each row). All to say, due to this constraint resulting from Smartsheet not recognizing multiple contacts derived from formulas, we have forced these entities to live with designating a single point of contact who must then handle all further distributions within their entity—again, a serious point of failure because we can't count on every designee from over a hundred entities to follow thru on passing along all messages to their colleagues.

Simply enabling multi-select Contact columns to recognize formula results—exactly as they ALREADY do before pressing Save—would solve all of these cases, and plenty of others.

@Olen Ronning Hopefully this is the best way to bump this topic again. There are individual roles that I set up as separate contacts columns to target notifications. However, I need to concatenate the separate contacts into one field so they can all have access to a Dynamic View that will tell them the status of the process and who it's currently sitting with.

This would be incredibly helpful. Here is my use case:

I am attempting to mass-edit my contact column for the purpose of Dynamic Views in a way that will add certain contacts based on the contents in other columns.

Example:

Column A is my contact column

Column B is "State"

Column C is "Department"

Column D is "Advisor"

If Column B=

• Illinois, then I want column A to include "Person 1"
• New York, then I want column A to include "Person 2"

If Column C=

• Math, then I want column A to also include "Person 3"
• English, then I want column A to also include "Person 4"

If Column D=

• Advisor 1, then I want column A to also include "Person 5"
• Advisor 2, then I want column A to also include "Person 6"

So, column A should have 3 people listed, but who those people are will depend on the values in B, C, and D. If I sort by B then add to A based on what is in that column, then that works for getting the right contact for the column B value. However, if I then sort by column C, is there a way to add the right contact to the contact column for these people without overwriting what is already in that column (and thus deleting what I had put in for B). I am looking to do this in mass (not manually adding to each cell) as I'm dealing with 1,500+ rows of data.