formula - contains

Sue van Niekerk

hi Guys i am trying a contains formula but doesn't want to work - what am i doing wrong?

i need my REF column to get a 1 in if IF Dept contains REF if not REF then blank

Genevieve P.

Hi @Sue van Niekerk

It looks like you just have a closing parentheses in the wrong spot! You'll want to "close off" the CONTAINS function before moving on to the rest of the IF statement.

I will note that although CONTAINS should work, the HAS function is built specifically for searching multi-select dropdown cells.

Try this instead:

=IF(HAS(Dept@row, "NIS"), "True")

Cheers,

Genevieve

Andrée Starå

Hi @Sue van Niekerk

I hope you're well and safe!

You've used a row number and the @ reference for a row.

Try something like this.

=IF(CONTAINS(Dept@row, "NIS", "True", "")

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sue van Niekerk

HI Andree

I am doing something wrong and doesn't seem to work - have tried with single bracket at the end and double bracket at the end

Genevieve P.

Hi @Sue van Niekerk

It looks like you just have a closing parentheses in the wrong spot! You'll want to "close off" the CONTAINS function before moving on to the rest of the IF statement.

I will note that although CONTAINS should work, the HAS function is built specifically for searching multi-select dropdown cells.

Try this instead:

=IF(HAS(Dept@row, "NIS"), "True")

Cheers,

Genevieve

Sue van Niekerk

Genevieve this work wonderfully - Thanks so much