if then formula with "or"

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

I have this checkbox formula field, based on if one or both of the following are true:

If([Total TCV]>5000000,true and [Weight]>0.2,true) or
If([Flagged for Vetting],true)

It's not working, as it is marking every record as true.

What am I doing wrong?

Photo of Nikki

Nikki

  • 284 Points 250 badge 2x thumb

Posted 4 years ago

  • 0
  • 1
Photo of Jesus

Jesus

  • 0 Points
Try combining the statements within a single sentence.

If([Total TCV]>5000000 and [Weight]>0.2 or [Flagged for Vetting], true, false) 
Photo of Nikki

Nikki

  • 284 Points 250 badge 2x thumb
thank you!  That worked.