I'm trying to create a field on the Case object that references a user picklist field on the Account object.

Using this:

Account.Customer_Success_Rep__c

Returns the correct user, but shows the Salesforce ID and I'd like the name.

My problem is that this:

TEXT(Account.Customer_Success_Rep__c)

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?

I'm trying to create a field on the Case object that references a user lookup field on the Account object.

Using this:

Account.Customer_Success_Rep__c

Returns the correct user, but shows the Salesforce ID and I'd like the name.

My problem is that this:

TEXT(Account.Customer_Success_Rep__c)

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?