Forum Discussion

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

DanaKrauss

Qrew Member

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

Qrew 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
------------------------------