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:
· Share on FacebookShare on Twitter

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 the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, and accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter
  • 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.

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!