Filtering and Formulas using a Multi- Select Text Field

Question

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 the "Primary Objectives" and will output text identifying the grant name. I tried using Contains([Primary Objectives]), "Objective 1", CEE,"
"CEE" is the desired output. Does anyone know if this is possible or maybe I can use dynamic form rules?

------------------------------
Nada Mousa
------------------------------

------------------------------Nada Mousa------------------------------

MarkShnierYou · Answer

You can do thisIF(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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Sign up

Login to the community