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).
- Change the rollup type to ARRAYJOIN(values) which gives you a string, which the FIND will work correctly with
- create a new formula field off the original rollup:
OrderStatus & ''
and have the FIND formula work off this.