Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Emoji replacing formula

613 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