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

    ------------------------------
    Nada Mousa
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      6 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
        6 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
        ------------------------------