Combine Multi-select Text and Text field

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Hello, I have three text fields and one Multi-select Text ([Network]) field what I want to combine to a new formula-text field. 

My formula looks like this:  

[Network] & " " & [Platform] & " " & [Product Version] & " - " & [Project Name]. However, it returns a string without Network value in it. Do I need to convert a format of a multi-select text to a text formal in the formula? If yes, how can I do it?

Thank you in advance for an answer.

Nadia Efimova

Photo of Nadezda

Nadezda

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Try this

List(" ", ToText([Network]), [Platform], [Product Version], [Project Name])



The Network which is a new Multi-select field type will come across as semi-colon delimited
Photo of Nadezda

Nadezda

  • 0 Points
Thank you very much! It works!