Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #366: Three Columns Are a Crowd

ggruccio
ACE Emeritus
ACE Emeritus

Made me think for a minute!

 

Saqueador
Used Transpose, Filter, Summarize (Concatenate) then just a matter of formatting.
ggruccio_0-1681145200031.png

 

eacheson
Meteoro
Saqueador
eacheson_0-1681149957014.png

 

ARussell34
Asteroide

My solution!

 

ARussell34_0-1681150544757.png

 

mmontgomery
Bólide

One long if-elseif statement

Saqueador
mmontgomery_0-1681151398132.png

 

CharlotteGuy
Asteroide
Saqueador
CharlotteGuy_0-1681151378150.png

 

olga_strubbe
Bola de fogo
Saqueador
olga_strubbe_0-1681156057867.png

 

A fun and tricky challenge, thank you very much! 

TurboToad
Bola de fogo

Fun challenge! 

Saqueador
TurboToad_0-1681159379450.png

 

Clifford_Coon
Bólide

My Solution.

 

Could use one tool if you didn't want to drop extra columns.

Saqueador
solution_366.jpg


2 Ways regular formula and multi-field.  I prefer regular formula. :-)

nagakavyasri
Quasar
Saqueador
Used Single formula tool:

Screenshot 2023-04-10 171046.png
CeliaC_Silje
Asteroide
Saqueador
CeliaC_Silje_0-1681178421084.png