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.
