Issue with CSV Download 'Manager' field has irrelevant information e.g. not name but a 24 digit string?

Org Chart
1

Hey,

Could anyone please advise how to resolve the issue when I export my 200 staff org structure (5 levels deep) to CSV, everything seems fine with the exception of the ‘manager’ section that has a ~24-digit reference instead of the line manager's name.

e.g. instead of Andy Morric its

c241ef99-0ec5-4298-9daf-a1d5eac01cb2
2

Hi @james.plumsail,

What you’re seeing in the Manager column is the unique ID of the manager that the user reports to. If you’d prefer to have a column showing the manager’s name instead of ID, you can add a simple Excel formula to look the manager up in the output CSV.

Add a new column called ManagerTitle, add the following formula there, then copy or drag it down:

=IF(IFERROR(VLOOKUP($B2,$A$1:$C$20,3,FALSE),"")=0,"",IFERROR(VLOOKUP($B2,$A$1:$C$20,3,FALSE),""))

image