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
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives