Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Formula with OR() & FIND()

Topic Labels: Formulas
418 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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)

CleanShot 2020-02-06 at 23.55.50

1 Reply 1

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