Pull In Managers Manager (rows are not using hierarchy)

Hello, Community! I could use some help with a formula. If Worker or Manager were using hierarchy, it seems like it would be more straightforward. So, what I'm trying to accomplish is a formula to pull in the Managers' Manager. In the below example, the person in Manager is the VP, the name in Worker is under him (so 01 and then 02 as the Org Level because I'm using that in other metrics widgets). In the Test column though for the other 250+ names, I want to pull in who a Worker's Manager reports to (their manager). I tried Index/Collect but not sure if that's 100% the correct or most efficient method.

Any help would be greatly appreciated :)...and thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!