Skip to main content

Formula with OR() & FIND()

  • February 7, 2020
  • 1 reply
  • 9 views
BobBannanas
Forum|alt.badge.img+13

Hey guys, – What am I doing wrong on this?

My goal is to:

IF (OrderStatus contains “ :blue_square: Completed”, “ :brown_square: Closed”, or both-- it should be 1(true)

1 reply

JonathanBowen
Forum|alt.badge.img+18

Hi @BobBannanas - I think this is because of the settings on your order status rollup field.

If this is set to “ARRAYUNIQUE(values)”, then it returns an array and the FIND formula won’t work consistently with this (in fact, I’m not sure why it works in any of the cases).

Two solutions:

  • Change the rollup type to ARRAYJOIN(values) which gives you a string, which the FIND will work correctly with

OR

  • create a new formula field off the original rollup:

OrderStatus & ''

and have the FIND formula work off this.

JB

Terms & ConditionsAccessibility statement