Condition formula

[Eduardo_Dalcin]

Hi folks!

I have this formula in a column:

CONCAT($nomeParticipante," (“,$instituicao.sigla,”)")

to produce this:

However, I would like to get rid of the “()” when the “$instituicao.sigla” is empty/null. How do I do this, please?

Thanks in advance!

Eduardo

[jarek]

Hi @Eduardo_Dalcin

You can use the IF expression to test for null/empty text:

IF($instituicao.sigla, CONCAT($nomeParticipante," (",$instituicao.sigla, ")"), $nomeParticipante)

[Eduardo_Dalcin]

@jarek

IF($instituicao.sigla, CONCAT($nomeParticipante," (",$instituicao.sigla, ")"), $nomeParticipante)

Brilliant! Perfect. Thanks!