Forum Discussion

JamieOwens_Knig's avatar
JamieOwens_Knig
Qrew Trainee
5 years ago

If Statement using Multi Select Fields

I have a tasks table where a user can pick a task from the task library (another table) and a library role field populates. However, they are also able to enter a new task with a new role. I've created a formula text field called Task Role to show the Library role or the new role, whichever is populated. But both fields are multi-select and it's giving me an error. Here is what I have for the the formula:

List (",",
If(Contains([Library - Role],""),[Select Task Role(s)]),[Library - Role])

Error is on the Select Task Role(s) field ... says expecting text but found text list.

------------------------------
Jamie Owens-Knight
------------------------------
Formulas and functions
  • BlakeHarrison's avatar
    BlakeHarrison
    Qrew Captain
    5 years ago
    If you want to manipulate information from a Multi-Select Text field in a Text formula, you must first convert it from a Text List to standard Text. The way to do this would be:
    ToText([Select Task Role(s)])​
    This will convert the Text List to a single string of semi-colon separated text values. If you want the list to use a different separator (such as a comma), you will need to also employ a search and replace function like this:
    SearchAndReplace(ToText([Select Task Role(s)])​,";",",")​



    ------------------------------
    Blake Harrison - DataBlender.io
    Quick Base Solution Provider
    ------------------------------