JBLS_ ✭✭✭
edited 12/09/19 in Formulas and Functions

Hello all, 

I'm looking to use a Created By column to auto-fill my Primary column with a specific user's first and last name. I was planning on listing each user's email and full name with some variation of a IF/AND/OR or IFERROR statement, unless there's a more efficient alternative. Here is my current and one of many incorrect formulas I've tried:

=IF(AND(IF([Created By]1 = "USER1 EMAIL", "USER1 FULL NAME"), IF([Created By]1 = "USER2 EMAIL", "USER2 FULL NAME"))

I'd also like to have this formula being auto-filled as new columns are being created by a web-based form. 

Thank you!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!