Can I create a formula checkbox where there are several conditions across fields?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need help building a formula for the following:

 

If Field A is equal to Local or Community AND at least 2 of several fields have "verified", then mark as checked.

 

Photo of Alison

Alison

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,208 Points 50k badge 2x thumb
no problem.  

We will use a formula variable to do an intermediate calculation first.



var number SeveralFieldsCount =

count(

[Field 1]= "verfified",

[Field 2]= "verfified",

[Field 3]= "verfified",

[Field 4]= "verfified",

[Field 5]= "verfified");



IF(

([Field A]="Local" or [Field A]="Community")

and

$SeveralFieldsCount >=2, true)