IF Contain

[BeaCruz (Beatriz Cruz)]

Hi Everyone

I am trying use this formula : IF(Contains({xxx}, “%”), “Sim”, “Não”)

What´s the problem?

xxx colunm is a text colunm

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Hi Beatriz,

Try

IF(SEARCH("%",{xxx}),"Sim","Não")

 
 

---

Want to take your formulas to the next level? Try the Advanced Formula Booster, the app that reinvents formulas in monday.

• Create formulas without using the Formula column (and avoid its limitations)
• Build formulas involving data from the previous item, the next item, the sub-items, the parent item, even items in the same group or the same board.
• In one formula, update multiple columns from multiple items.

Check our blog for real use cases.

[BeaCruz (Beatriz Cruz)]

Hi @GCavin
Unfortunally the answer keep wrong

[GCavin (Gilles Cavin - Reinventing Formulas in monday.com)]

Try

IF(SEARCH("%",{xxx})>0,"Sim","Não")

[BeaCruz (Beatriz Cruz)]

Thank you so much @GCavin
Now it is working!!!