Calculated field to show ONLY last name from User list

[Rscofidio]

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

[KellieGardner]

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.