Emoji replace formula

Topic Labels: Formulas
591 0
Showing results for 
Search instead for 
Did you mean: 
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.


Screenshot 2020-10-28 at 10.59.33

0 Replies 0