Combine two separate contact cells into one cell.

09/12/19 Edited 12/09/19

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?

Capture.PNG

Comments

  • Paul NewcomePaul 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.

    thinkspi.com

  • Andrée Starå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

    work-bold

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

    thinkspi.com

  • Andrée StaråAndrée Starå ✭✭✭✭✭

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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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.

  • Paul NewcomePaul Newcome ✭✭✭✭✭

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

    thinkspi.com

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    haha

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    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.

  • 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?

  • Andy LoranceAndy 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.moss89851pamela.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([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]#, "")))

  • TravisKTravisK ✭✭✭✭✭

    @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

  • 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.


Sign In or Register to comment.