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

Options

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

Cierr Limited

Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

https://www.cierr.com

Best Answer

  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭
    Answer ✓
    Options

    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

    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

    https://www.cierr.com

Answers

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    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)

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭
    Answer ✓
    Options

    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

    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools

    https://www.cierr.com

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!