ContributionsMost RecentMost LikesSolutionsRe: Multiple true conditions in an If statement formulaMark, 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 ------------------------------ Multiple true conditions in an If statement formulaHey 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 ------------------------------