We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

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

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #286: Who turned the lights off?

ahmedirfanp
7 - Meteor

My Solution for this Challenge. 

BronzeFox
8 - Asteroid
Spoiler
BronzeFox_0-1634586222183.png

 

danespoors
8 - Asteroid

Took me quite a while annoyingly. I never think of using the find and replace tool.

SgdPackard810
8 - Asteroid

Shoutout @Aaron_Harter for a little reminder of the find + replace tool. Messed around with a cross-tab and IN operator within the formula tool for waayyy too long trying to get this. Elegant solution you had there that helped me get the exact configuration I was seeking!

Rupal03
7 - Meteor

Awesome challenge 🙂

My Solution is here :

DaisyJones
8 - Asteroid

Here is my solution

 

Spoiler
Challenge 286.png

alishadhillon__
7 - Meteor

I definitely don't use the Find and Replace tool enough and so this was a good way to practice and attempt playing around with the configuration until I got my desired result. Really good challenge!

Screenshot (40).png

JosephSerpis
16 - Nebula
16 - Nebula

Challenge Completed

 

Spoiler
Weekly_Challenge_286.JPG
ehughes
9 - Comet
Spoiler
ehughes_1-1635170525980.png

 

SunderlandHughes
6 - Meteoroid
Spoiler
SunderlandHughes_0-1635174592019.png