Help

Emoji replacing formula

548 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Unai_Ezkurra
5 - Automation Enthusiast
5 - Automation Enthusiast

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.

ba18597c311935a2fe1c2d7473b1031f642f2a8e.png ba18597c311935a2fe1c2d7473b1031f642f2a8e.png

0 Replies 0