Forum Discussion
NadaMousa
6 years agoQrew Trainee
I am only checking for the objectives from that one "Primary Objectives" filed
------------------------------
Nada Mousa
------------------------------
------------------------------
Nada Mousa
------------------------------
MarkShnier__You
Qrew Legend
6 years agoSo all good now?
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- NadaMousa6 years agoQrew TraineeYes 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__You6 years ago
Qrew Legend
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
------------------------------