Forum Discussion

awood's avatar
awood
Qrew Member
2 days ago

Combining AND with OR in Formula Checkbox Field

Hi all, I'm trying to set up a checkbox that gets checked when a number of conditions are specified. Here's my current formula: If(Contains([Type],"Leader") or Contains([Type],"Managing") or Cont...
formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    2 days ago

    Try this

    IF(

    (Contains([Type],"Leader")
    or Contains([Type],"Managing")
    or Contains([Type],"Associate"))


    and [Forecast Due Date]=Today()
    and [Revenue]=0
    and [Work Status]="Active"
    and [Frequency of  Pay] = "Monthly"
    ,true
    ,false)

     

awood's avatar
awood
Qrew Member
2 days ago

As per usual with my formula woes, it came down to placement of parentheses! Thank you so much!