Forum Discussion

NadaMousa's avatar
NadaMousa
Qrew Trainee
5 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
Qrew Champion
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
mark.shnier@gmail.com
------------------------------
NadaMousa's avatar
NadaMousa
Qrew Trainee
5 years ago
I am only checking for the objectives from that one "Primary Objectives" filed

------------------------------
Nada Mousa
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    5 years ago
    So all good now?

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • NadaMousa's avatar
      NadaMousa
      Qrew Trainee
      5 years ago
      Yes just a quick clarification,  can I do IF(Contains(ToText([Primary Objectives]), "Objective 1" or "Objective 2"), "CEE")  I am trying to make sure I can capture multiple objectives that go under one grant. Thank you so much! Hope you are staying safe and well!



      ------------------------------
      Nada Mousa
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        5 years ago
        you will need this syntax

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

        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        mark.shnier@gmail.com
        ------------------------------