Exporting to excel appends characters to the user field

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
When I export a report to excel, a user column (sales supervisor) exports to excel as "user name with the number being some random combination. How do I avoid this being appended in the excel file?
Photo of Kevin Henri

Kevin Henri

  • 70 Points

Posted 2 years ago

  • 0
  • 1
Photo of Chris

Chris

  • 4,430 Points 4k badge 2x thumb

You can create a formula text field and export that instead:

usertoname([user field])

This will convert the user field to a plan text field.

No problem.

Make a new formula text field called [User Name] with a formula of
UserToName([Sales Supervisor])

Use that on your report instead.