Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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