change name from @cell to email in another @cell


what could be the Formula in @cell "b" to insert the email address of a person whose name is written in cell "a" ?

Best Answer


  • Dustin_berg
    Dustin_berg ✭✭
    edited 10/07/22

    I was able to use this formula in my sheet without a helper sheet. First, I created a First Name helper column and used the formula =LEFT([Contact]@row, FIND(" ", [Contact]@row) - 1), then I created a Last Name helper column with the formula =MID([Contact]@row, FIND(" ", [Contact]@row), 100). Finally, I created the email column and used the formula =[First Name]@row + "." + [Last Name]@row + ""

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!