How to I "not format" a number in a form?

Lainie Franklin
Lainie Franklin ✭✭✭✭
edited 12/09/19 in Formulas and Functions

One of the questions on my form is what year(s) someone attended our annual meeting. The format is text/number. if someone attended in 2016, 2017, and 2018, the answer is being formatting with commas and displays as 201,620,172,018 even though I typed it as 2016, 2017, 2018. The only way around it is to direct people to put slashes between the years (2016/2017/2018). 

Any clues on how I can get Smartsheet to NOT format a number or to recognize the year as text?  I don't see a way to apply a formula when the information is coming into the sheet via a form.  

 

 

«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!