Calculated field to show ONLY last name from User list | Community
Skip to main content
R
Rscofidio
New Participant
September 5, 2025
Question

Calculated field to show ONLY last name from User list

  • September 5, 2025
  • 1 reply
  • 196 views

Hi,

 

We have a field called Story Lead that appears on several custom forms. This field pulls from the regular user list to poulate.

 

Can I create a custom field that would pull in JUST the last name of the person indicated as the Story lead?

 

I have tried a variant of this: 

 

{DE:Story Lead}.{name}. 
SUBSTRING({DE:Story Lead}.{name}, ADD(FIND({DE:Story Lead}.{name}, " ", -1), 1))

But it keeps telling me that Name is incorrct in the string.
 
Anyone have any thoughts?
 
Thanks,

Robin

1 reply

KellieGardner
KellieGardner
New Participant
September 5, 2025

Assuming your first field, "DE:Story Lead" is a typeahead field using User as the Referenced Object Type, you could set up your calculated field to just be 

 

{DE:Story Lead}.{lastName}
 
And it should return just the last name of the user selected.
 

 

    Terms & ConditionsAccessibility statement

    Loading footer...