Convert to Column Formula = Specific Word

Options

Hello,

I want to make a column automatically populate a text word (i.e. CMHA) using Covert to Column Formula. I have done this in the past with a number but cannot remember and keep getting an error. I would appreciate your help!

Tags:

Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓
    Options

    I'm not sure I understand. Does this work:

    Enter this formula in the column you want the text to appear in:

    ="CMHA"

    Right click on the cell and choose "Convert to Column Formula"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!