Using the Created By to populate a Contact Column with the full name rather than email

I am setting up a timesheet and I want to use the Created by Column to populate a name contact column.

When I use the formula in Name column to copy what is in Created by, it gives me the email address.

Am trying to find a method for it to do this

I can't a formula to convert to person and I have made this a contact field.

It isn't the end of the world but having this as the full name when I know it can hold that data (particularly because of reporting) would be great.

Thanks everyone and having a wonderful Christmas and very happy new year.

Kind regards

Purnima

Find more posts tagged with

Accepted answers

Purnima Gore

I have used the helper columns but was hoping that there was a solution out there without the need for additonal columns

Kind regards

Purnima

All comments

Bassam Khalil

Hi @Purnima Gore

Hope you are fine, you can do that by creating a help sheet contain the Email & the full name for all your company employee then in the name contact column you can get the full name by using =VLOOKUP([Created By]@row, Contact:Contact, 1)

Purnima Gore

I have used the helper columns but was hoping that there was a solution out there without the need for additonal columns

Kind regards

Purnima

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.