Combine two separate contact cells into one cell.

Chester Guinto

With the new update to Vlookup adding contact list functionality, would there be a way to combine two individual contact cells into one cell with both contacts using an equation/formula?

Paul Newcome

I have dug through quite a few delimiters, but haven't been able to find one that works yet. I will revisit if I do find one. Until then... Feel free to submit a Product Enhancement Request.

Andrée Starå

Hi Chester,

Unfortunately, as far as I know, it isn't possible at the moment.

I agree with Paul, Please submit an Enhancement Request when you have a moment.

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

Paul Newcome

I don't know why mine didn't link. Haha. Thanks.

Andrée Starå

It works but just doesn't look like a link. 

Paul Newcome

Hmm... That's even more odd. Haha

Andrée Starå

John Kennedy

It can be done with the following formula:

=[column name]<row number> + "-" + [column name]<row number>

So if you have 2 columns, "First Name" and "Last Name" with row one containing "John" and "Doe" respectively the formula:

=[First Name]1+" "+[Last Name]1

would give you a cell with contents "John Doe"

If only I could figure out a way to do this across sheets, I would be happy.

Adam Harbison

John, I believe that will only work for text, but not contact lists with associated email addresses, correct?

Andy Lorance

Good afternoon, team - I found this thread when looking for the same solution as the original post above. Anyone know if there are recent developments that allow this function?

Thanks!

pamela.moss89851

I too would love a solution. We need to have a contact list column with multiple contacts set by a formula that will be used as a filter in a Dynamic View. Dynamic View must be able to see the data as a contact not a string. Right now the only solution we have is to have as many contact list columns as the max number of potential contacts. Then we can't have one Dynamic View. We have to have the same number of Dynamic Views as potential contacts for a given row.

My current solution:

Summary Fields for Each Regional Contact(s)

Formula to set 1st Contact List Column: =IF(Region@row = "Central", Central#, IF(Region@row = "Northwest", Northwest#, IF(Region@row = "Northeast", Northeast#, IF(Region@row = "Southeast", Southeast#, IF(Region@row = "Southern", Southern#, IF(Region@row = "Suncoast", Suncoast#, ""))))))

Formula to set 2nd Contact List Column: =IF(Region@row = "Southern", [Southern2]#, IF(Region@row = "Suncoast", [Suncoast2]#, IF(Region@row = "Southeast", [Southeast2]#, "")))

TravisK

@pamela.moss89851

Hi Pamela,

On your dynamic view, if you are trying to Restrict View by Current User, but you want to restrict the view by using multiple columns from your source sheet (for example a Manager column and a Team Member column), you can use a Smartsheet Report to accomplish this.

Create a report that mirrors your source sheet, but set the filters to Manager = Current User OR Team Member = Current User.

Then use the report as the source for your Dynamic View.

You won't need to use the Restrict View by Current User option in the Dynamic View because the report will already be accomplishing this for you.

Hope that helps.

Travis

Albert Hart

You can now combine two contact fields into one contact field by using the "Assign People" workflow.

The assigned person in the trigger needs to match the assigned person on the action. Make sure the column where the contacts end up is a multi contact column and that the following in the workflow is unchecked.

Robocop55

In trying to concatenate contacts, my issue with the "Assign People" workflow is that I can't use the user inputted person into that destination column.

i.e. I'd like to use the 'Any Value' for column 'Author' into the column "All Stakeholders" along with all other contacts already in 'All Stakeholders'

Is there still a solution for concatenating contacts into one column where Smartsheet actually pick up on their email/userid contacts?

Krystle McMaster

https://community.smartsheet.com/discussion/comment/316158#Comment_316158

Hi there - I'm trying to figure out how to implement this as a workaround but I'm hitting a wall. When I build this automation, I have to pick a specific person to assign in the action. I can't set it up to say if there is a name in column A, assign the same contact into Column C.

Were you able to do that or were you building actions for each person that may be assigned to each column? That seems like A LOT of actions and not scalable as teams grow and evolve.

Thanks,

Krystle

Rachael Stammers

Hi I used @John Kennedy solution =[column name]<row number> + "-" + [column name]<row number> to add a corrective action number to a hazard identification number (See images below) and it works perfectly. However, I want to add an IFBLANK statement, So, if there is no corrective action identified, the cell will remain blank.

My formula is so simple

=[Hazard Report ID #]@row + "-" + [CA1]

• HSHR-23-001 is the Unique ID auto generated in Smartsheet.
• I used an auto fill option in a hidden column to generate CA1 (Corrective Action 1), CA2 etc.

All help greatly appreciated