Formula to change a name to their numeric ID

Options

Can I get assistance in writing a formula that will look at who created the row and instead of showing their name I want it to show their numeric ID i assign to them?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓
    Options

    Start typing the formula:


    =INDEX(


    Then in the helper box there should be a link to "Reference Another Sheet". Click on that link, select the sheet you want to reference, then click on the column header that you want to reference. Changing the reference title is up to you. I generally change it to sheet name and column name so it is easier for me to follow.


    Once you click on the blue button in the bottom right corner of the popup window, it should take you back to the sheet you were working on and have the cross sheet reference inserted. Just finish out the formula using the above steps to create the other cross sheet reference and you should be good to go.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!