Forum Discussion

ElizabethSchlag's avatar
ElizabethSchlag
Qrew Member
7 months ago

IF OR Statement Errors

I am trying to create a formula that if a supplier name is equal to XXX, XXX, or XXX then check the supplier requires legal review box, however I keep getting different errors. Here is my current formula, any advice?

If(
        [Supplier] = "Workday" OR
        [Supplier] = "Amadeus" OR
        [Supplier] = "Flightkeys" OR
        [Supplier] = "Google"
    ,
    true,
    false
)

I have also tried:

If(
    Or(
        [Supplier] = "Workday",
        [Supplier] = "Amadeus",
        [Supplier] = "Flightkeys",
        [Supplier] = "Google"
    ),
    true,
    false
)



------------------------------
Elizabeth Schlagel
------------------------------

2 Replies

  • Make sure the field type for your check box is Formula Checkbox" whcih is sounds like it already is and then the formula is: 

    If([Supplier] = "Workday", true, [Supplier] = "Amadeus", true, [Supplier] = "Flightkeys", true, [Supplier] = "Google", true, false)



    ------------------------------
    Personal Tax Team
    ------------------------------
  • Your first formula with the [Supplier]="" OR syntax looks fine. Do you have an example where it's not responding as intended? Double check that your supplier entries match exactly what is in your data, QB is case sensitive so if you anticipate that being an issue you can always do Lower([Supplier]) = "workday" as an example 



    ------------------------------
    Chayce Duncan
    ------------------------------