Forum Discussion

DanaKrauss's avatar
DanaKrauss
Qrew Member
4 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
Icon for Qrew Legend rankQrew Legend
4 years ago
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
    4 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
      Icon for Qrew Legend rankQrew Legend
      4 years ago
      sure

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

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