Forum Discussion

NadaMousa's avatar
NadaMousa
Qrew Trainee
6 years ago

Filtering and Formulas using a Multi- Select Text Field

I am trying to organize our work with out grant objectives. I have now a multi-select field with the objectives written in its called "Primary Objectives". I want to create a field that can read from ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
6 years ago
You can do this

IF(Contains(ToText([Primary Objectives]), "Objective 1"), "CEE")

But are you just checking for the objectives in separate fields or do you want a list of them based on all the selected Primary Objectives?

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
[email protected]
------------------------------