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!

 

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

 

eacheson
7 - Meteor
Spoiler
eacheson_0-1681149957014.png

 

ARussell34
8 - Asteroid

My solution!

 

ARussell34_0-1681150544757.png

 

mmontgomery
11 - Bolide

One long if-elseif statement

Spoiler
mmontgomery_0-1681151398132.png

 

CharlotteGuy
8 - Asteroid
Spoiler
CharlotteGuy_0-1681151378150.png

 

olga_strubbe
11 - Bolide
Spoiler
olga_strubbe_0-1681156057867.png

 

A fun and tricky challenge, thank you very much! 

TurboToad
10 - Fireball

Fun challenge! 

Spoiler
TurboToad_0-1681159379450.png

 

Clifford_Coon
11 - Bolide

My Solution.

 

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

Spoiler
solution_366.jpg


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

nagakavyasri
12 - Quasar
Spoiler
Used Single formula tool:

Screenshot 2023-04-10 171046.png
CeliaC_Silje
8 - Asteroid
Spoiler
CeliaC_Silje_0-1681178421084.png