Convert to Column Formula = Specific Word



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!


Best Answer

  • KPH
    KPH ✭✭✭✭✭✭
    Answer ✓

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

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


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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!