Emoji replacing formula

Hello community

I’m trying to add this function to the main column.

This is the formula concatenate I use to show specific data.

CONCATENATE({:anger:Nombre Jugador},’ ‘,’|’,’ ‘, MID({:anger:Año},3,2)) &’ '& {:star: :x: :heavy_dollar_sign::older_man:t2:}& {:fire:}& ’ | '&{:anger:Club 20/21}

What I am looking to do is replace the star :star: emoji by :fire: when this column contains the emoji. And when doesn’t maintain the :star: emoji.

Thanks in advance for your time and effort.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.