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?
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.
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!
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.
I don't know why mine didn't link. Haha. Thanks.
It works but just doesn't look like a link.
Hmm... That's even more odd. Haha
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.
John, I believe that will only work for text, but not contact lists with associated email addresses, correct?
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?
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([email protected] = "Central", Central#, IF([email protected] = "Northwest", Northwest#, IF([email protected] = "Northeast", Northeast#, IF([email protected] = "Southeast", Southeast#, IF([email protected] = "Southern", Southern#, IF([email protected] = "Suncoast", Suncoast#, ""))))))
Formula to set 2nd Contact List Column: =IF([email protected] = "Southern", [Southern2]#, IF([email protected] = "Suncoast", [Suncoast2]#, IF([email protected] = "Southeast", [Southeast2]#, "")))
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.
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.
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?
©2022. All Rights Reserved Smartsheet Inc.