Can anyone help on a "if" formula?

I am asking; If [description] contains "kite" the result should be 1 otherwise 0

I have tried from gemini

if(test([Description], "Kite"), 1, 0)
if(test([Description], /kite/i), 1, 0)
count(match([Description], /Kite/i)) > 0 ? 1 : 0
size(filter([Description], "Kite")) > 0 ? 1 : 0

but none of them will work, any ideas?

Steve Golubov 20m 2s

Hi Kevin,

At the moment, zzTakeoff does not reliably support checking whether a description contains specific text such as “kite” within a formula. I found that all my test formulas with " " are not working.

Because of this limitation, the solution I've implemented uses a dedicated field called [Kite] instead of trying to detect the word in the description.

The way it works is:

If the item is marked as Kite (value greater than 0), the formula returns 1
If it is not marked (value is 0 or blank), the formula returns 0

In simple terms, the formula converts the input into a clear yes/no result:

0 = Not a Kite item

1 = Kite item

Hope this helps

You must be logged in to post replies. If you don't have an account you can signup here.