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 #14: Warehouse Distribution

cgoodman3
14 - Magnetar
14 - Magnetar

Without a macro for this one:

Spoiler
Challenge 14.PNG
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
DiegoParker
10 - Fireball

I must say I didn't know how to do this with a macro so I just used a few multi-rows.

RobertoEstrada
8 - Asteroid

Here is my solution. Probably not the best so I need to continue practicing a lot the use of the different tools available.

Cory_Snook
6 - Meteoroid

Messy but effective.

Spoiler
challenge14.png
NoraW
7 - Meteor

Tried out the iterative macro approach...

 

Spoiler
Macro.PNGMain workflow.PNG

 

echuong
8 - Asteroid

A little bit of a different approach than the posted solution...the instructions didn't say to allocate products to stores that didn't have a requirement, so my answer differs a little

jagdeep_singh85
8 - Asteroid

PFA my solution

Lily_Unsworth
8 - Asteroid
 
joemkcarr
8 - Asteroid

Done with a batch and an iterative macro to practise

Asal
7 - Meteor

This is mine,still thinking if I can replace  a formula instead of Running Tool+ Multi-Field Formula!