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 create...
Forum Discussion
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:
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:
------------------------------
Blake Harrison - DataBlender.io
Quick Base Solution Provider
------------------------------
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
------------------------------
