Formula to return User Name from Created By

Options
Jiri
Jiri ✭✭
edited 05/09/24 in Formulas and Functions

Is there a formula to return User Name from Created By?

Tags:

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭
    Options

    create a reference sheet that had the username and the email. The. Use index match formula to pull the user name

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • Jiri
    Jiri ✭✭
    Options

    This is very cumbersome, because first one has to create the list of users; second one have to add new users into that list. (I have actually done that)

    It would be much more efficient if I could get the User Name from record creator column/field.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!