Discussions

Expand all | Collapse all

Multiple true conditions in an If statement formula

  • 1.  Multiple true conditions in an If statement formula

    Posted 09-17-2021 10:20
    Edited by Dana Krauss 09-17-2021 10:20
    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
    ------------------------------


  • 2.  RE: Multiple true conditions in an If statement formula

    Posted 09-17-2021 10:23
    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
    ------------------------------



  • 3.  RE: Multiple true conditions in an If statement formula

    Posted 09-17-2021 10:37
    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
    ------------------------------



  • 4.  RE: Multiple true conditions in an If statement formula

    Posted 09-17-2021 10:44
    sure

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

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