Can this possibly be true - that Smartsheet doesn't have column validation for numbers?
I'm sat here flabbergasted. Can it possibly be true that Smartsheet doesn't enable you to natively enforce simple validation rules such as:
a) Entry being a number
b) Being between 2 values
Really? I'm baffled by this. Surely the devs would have realised this is an essential feature on DAY 1?
I can only assume they are either gaslighting us or making sure they have work to do in the future.
If this feature is hiding somewhere in plain sight, please put me out of my misery.
Text/Number? Seriously?
Best Answer
-
Thanks for the honest feedback Ed. There are several forms of validation available in Smartsheet. You can force entry for checkboxes, contact/email, symbols, dropdowns and other column types. Also you will find validation in the form settings, if you click on any text field and look in the right pane for the setting you can select between Number Only, Percentage, Email, Phone, and No Validation. If this isn't what you are looking for, you can use our feedback form which will be reviewed by the Product team for a future enhancement to the product.
Feedback Form: https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?What%20is%20your%20feedback%20about%3F=Forms&Origin=com-us
Answers
-
Thanks for the honest feedback Ed. There are several forms of validation available in Smartsheet. You can force entry for checkboxes, contact/email, symbols, dropdowns and other column types. Also you will find validation in the form settings, if you click on any text field and look in the right pane for the setting you can select between Number Only, Percentage, Email, Phone, and No Validation. If this isn't what you are looking for, you can use our feedback form which will be reviewed by the Product team for a future enhancement to the product.
Feedback Form: https://app.smartsheet.com/b/form/739aa75f30ca43a8a22eb53e4da7d409?What%20is%20your%20feedback%20about%3F=Forms&Origin=com-us
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives