Forum Discussion

awood's avatar
awood
Qrew Member
2 months 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 months 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)

     

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
2 months 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)