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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.