Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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 #65: Fulfilling Inventory Orders

JP_SDAK
8 - Asteroid

This was harder than I thought it would be!

MikeLR
8 - Asteroid

 

Spoiler
Nice chance to practice using the multi-row formula. I only realised afterwards that I needn't have used the Tile tool.
MikeLR_0-1594253919971.png

 

KirstyHarvey
8 - Asteroid

Gotta love a MRF!

AnaisComyn
9 - Comet

Done !

jarrod
ACE Emeritus
ACE Emeritus

honestly, took me a while to figure out what was being asked... went with an iterative macro approach for fun.

Spoiler
jarrod_0-1594394830188.png

 

jarrod_1-1594394845637.png

 

Harkamal
8 - Asteroid

my solution

mag161
8 - Asteroid

Slightly different, but overall the same idea to some of the solutions on the first page.

psampaio005
8 - Asteroid

It took a while to figure out how to make the IF statement work on this case.

Spoiler
#65 - Solution - PS.JPG
Samanthaj_hughes
ACE Emeritus
ACE Emeritus

🙂

#Alteryxrocks
Arturo90
7 - Meteor

My solution using Unique tool