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 #237: Wareki

DeanWest
9 - Comet

Fun challenge and great practice for creating macros!

 

 

Spoiler
challenge_237_solution-DeanWest_snippet.png

 

 

 

paulfound
11 - Bolide

Bit late to the party this week 😞

 

Spoiler
PaulFound_0-1602665386428.png

 

ggruccio
ACE Emeritus
ACE Emeritus

Fairly simple - although....

 

Spoiler
Used the Detour tool and had my logic reversed!  So I had to "cross streams" to fix it.
ggruccio_0-1602704982061.png

 

Romy
7 - Meteor

This is my solution to this week's challenge. Borrowed the radio button idea from the first post by @johnemery, but the rest of solutions are entirely different. 

PoojaMekala
5 - Atom

My first weekly challenge submission!

 

Quick question - In my macro, selecting both the input (Field1) and output fields was causing an error stating the field schema changed between iterations. To avoid this I used a formula with the update tool for the input field. 
Please let me know on how I can avoid this error.

 

Thank you!

atcodedog05
22 - Nova
22 - Nova

Fun challenge 🙂

 

Spoiler
Macro
atcodedog05_0-1602769590505.png

Workflow:

atcodedog05_1-1602769610382.png

 

Cheers and Happy Analyzing 😀 

mustel
8 - Asteroid

Not the most elegant macro, realised I could have done a lot more of it in the formula tool, but hey it works!

 

Spoiler
mustel_0-1602769970722.png

 

Spoiler
mustel_1-1602770011423.png

 

Spoiler
mustel_2-1602770039470.png

 

balajilolla
8 - Asteroid
Spoiler
Solution Attached. Learnt about the Detour tool

balajilolla_0-1602789237588.png

 

estherb47
15 - Aurora
15 - Aurora

Fun with dates!!

 

Spoiler
The workflow: 
EstherB47_0-1602816025574.png



The magic: 

EstherB47_1-1602816040694.png

 

Cheers!

Esther

mbogusz
9 - Comet
Spoiler
2020-10-16 08_12_45-Greenshot.png