Skip to main content

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({ 💢 Nombre Jugador},’ ‘,’|’,’ ‘, MID({ 💢 Año},3,2)) &’ '& { ⭐ ❌ 💲 👴t2: }& { 🔥 }& ’ | '&{ 💢 Club 20/21}


What I am looking to do is replace the star ⭐ emoji by 🔥 when this column contains the emoji. And when doesn’t maintain the ⭐ emoji.


Thanks in advance for your time and effort.


Regards.


Be the first to reply!

Reply