Number validation in form not allowing dash (-)
This help article states that dash (-) is a permitted character for number validation in a form: https://help.smartsheet.com/articles/2482427?_ga=2.261669517.1481821032.1673447251-1366866786.1665082147
However, my form is NOT allowing that. I'm trying to ensure my team enters the Project ID (not the name as is commonly done). In my sheet, the Project ID is the primary column and therefore is a text/number column. The ID is structured as 1234-123. I tested by creating a text/number column and the form still will not allow a dash. I've also tested by manually typing the number and by copy & paste - neither work.
Answers
-
It is because the dash is in the middle which converts it into a text string. When they say the dash is a valid character, they are meaning as the first character to indicate a negative number.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives