Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

    ✭✭
    in Formulas and Functions

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

    · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭✭

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

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

      · Share on FacebookShare on Twitter
    • ✭✭

      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.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions