Forum Discussion
Need Help with Logic on Employee Level
Hello, I am trying to understand how I can set Level of Heirarchy on a column where itis a list of employees from CEO to Associates. Associate Report to Managers Managers report to Leaders Lead...
Hi,
I think the ideal is just to find out how many layers of "Direct Report" an employee has to go through to reach "CEO".
e.g, Manager1, who reports to Leader2, who in turns reports to CEO, needs to go through 3 people to reach CEO, so Manager1's level is 3.
I implement it in Excel using some lookup formulas.