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

Purnima Gore

Hi

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

Purnima Gore

Hi

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

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

Hi

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