We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #12: Creating an HR Hierarchy

Numa
7 - Meteor

Screenshot 2023-11-20 122040.png

Archie_bos
8 - Asteroid

here is my solution

Myles_Stevenson
8 - Asteroid
Spoiler

Here it the macro i made for this solution

Screenshot 2023-11-22 163253.png

 

Rob-Silk
8 - Asteroid

My solution below:

Spoiler
challenge_12a_RS_screencap.PNGchallenge_12b_RS_screencap.PNG
JimmyV
8 - Asteroid

Well, It's pretty obvious I wasn't looking at other solved solutions... Haha! Oh well, glad to of solved it.

 

Spoiler
Solution.png
caitlynmcintyre
9 - Comet
Spoiler
12.png12 m.png
SamMitchell2
5 - Atom

Hi Everyone! I have a very similar use case to this and have been trying to work out how I could tweak the macro.

 

In my case I have Employee ID and Manager ID. What I want to do is start with the top (CEO) ID (assign as Level 1), then identify who they manage (Level 2), and so on and so forth until the bottom of the hierarchy. 

 

Could anyone advise how I could modify the solution for this use case?

 

Thank you :)

westlakecjw
7 - Meteor
Spoiler
image.png
SidSaythongphet
7 - Meteor
Spoiler
Challenge 12 Solution.jpg

BrianJohnson
7 - Meteor

The practice of macro creation was big reason that I started the weekly challenges.  I'd like to say this went easily, but it was a big struggle.  However, with the help of your solution, I was able to get through it and then created it a second time.  I believe I learned a great deal.