Skip to main content
Question

Multiple true conditions in an If statement formula

  • September 17, 2021
  • 0 replies
  • 535 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • September 17, 2021
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
------------------------------