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 Form],[Photo ID]=true, true) //checks "Paperwork Complete" if fields are also checked

...but I can't seem to add more than that. From what I've read, the case function would check "paperwork complete" if any of the listed fields are checked. How would I expand the if statement to an if/and so that "paperwork complete" is only checked if all the listed fields are also checked?

Thank you!

------------------------------
Dana Krauss
------------------------------
Formulas and functions

3 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 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
      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
        ------------------------------