I'm trying to create a field on the Case object that references a user lookup field on the Account object.
Returns the correct user, but shows the Salesforce ID and I'd like the name.
My problem is that this:
Gives me this error:
Error: Incorrect parameter type for function 'TEXT()'. Expected Number, Date, DateTime, Picklist, received Lookup(User)
Why isn't this working? How can I get the text of the field?