Forum Discussion

DanaKrauss's avatar
DanaKrauss
Qrew Member
3 years ago

Multiple true conditions in an If statement formula

Hey all, I'm trying to set up a checkbox formula to only be checked "if" about 10 different fields are all also checked off. I was able to make the function work with 2 variables: If([Personal Data F...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
This will work.  if you are checking other checkbox fields, then just "and" them together like this.  Do not need to have an IF.



[Personal Data Form]
and
[Personal Data Form]
and
[Photo ID]
and
[my next field]
and
[my next next field]





------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
DanaKrauss's avatar
DanaKrauss
Qrew Member
3 years ago
Mark, thank you so much! This worked. Perhaps better fit for a different thread, but is there a way to add 2 identical text - multiple choice fields to the and statements? We are looking for the functionality noted in the comments below:

[Personal Data Form]
and
[Photo ID]
and
// if drug screen is selected as "Completed"
and
// if background check is selected as "Completed"

------------------------------
Dana Krauss
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    sure

    [Personal Data Form]
    and
    [Photo ID]
    and
    [drug screen] =  "Completed"
    and
    [background check] =  "Completed"

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------