Emoji replace 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.

Regards.

Screenshot 2020-10-28 at 10.59.33

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