Condition formula

Hi folks!

I have this formula in a column:

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

to produce this:

image

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

Hi @Eduardo_Dalcin

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

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

Brilliant! Perfect. Thanks!