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 Gore

Cierr Limited

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!