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 #1: Join to Range

Kalposki
7 - Meteor

One generate row that starts with the Left of Range until the Right of the smae field.

Then Join and Summarize.

mmariano
6 - Meteoroid
Spoiler
Screenshot 2024-02-26 185204.png
JohnMcFadyen
5 - Atom

Kept it simple with an 'if else endif' formula and join onto record Ids on the reference table. Did the trick

 

Capture.PNG

pmag
8 - Asteroid
Spoiler
Screenshot 2024-02-28 143751.png

going OG

DWingelaar
6 - Meteoroid

Feels like I bruteforced it a little bit, but a good way to start these challenges I think

JosephO
5 - Atom

I wrote a simple IF statement to match the lookup field. A pretty simple solution utilizing just the formula tool.

 

 

Volha
8 - Asteroid

 

Spoiler
 
1.png

JakubJ
8 - Asteroid

Hi, it's my solution. Regards

challenge_1_finished.png

aatalai
13 - Pulsar

back to the start

leonardstarrk
8 - Asteroid

Not bad!