Convert to Column Formula = Specific Word
Options
jelfner
✭✭✭
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

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

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"

Thank you, that worked great!

Glad I could help!
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!