is there a way to enter a number that shows up as a text?


for ex, evter in a column "1" and it generates a job title. also, can i combine that with multiple jobs in each cell??


  • Christian G.
    Christian G. ✭✭✭✭✭✭

    To enter a number as text, Try this " '1 "

    and I don't understand the rest of the question.

  • Wolfram
    Wolfram ✭✭

    Hi nctd,

    Yes. there is fairly simple way to accomplish that with automation. Click on Automation on the top left corner of the screen. In the dropdown menu click "Create a workflow from scratch."

    In the Trigger part, change Any Field to the column where you want to enter the numbers.

    Change Add a Value to 1 (or 2 or 3).

    In the Select an action part, click on Change cell Value.

    Select the column where you want the jobtitle to go. (Can be the same as the number column.)

    Enter the new value, e.g. CEO or dishwasher.

    Repeat for all numbers.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!