How to I "not format" a number in a form?
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.
Help Article Resources
Check out the Formula Handbook template!