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
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 138 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives