Restricting Text/Number Columns to a Format
Hello all,
I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is something that would be extremely useful to have, especially with the amount of forms that I, along with my Smartsheet colleagues, use on a regular basis.
If Smartsheet were to add this feature, it would make the use of forms much more robust.
Thank You
Comments
-
Hello,
You can, to a certain degree, restrict columns to only allow certain data types. (More on this in the Column Types help article.)
You are correct that Smartsheet doesn't currently have this level of data validation such that a column is restricted to certain characters and character limits.
When you have a moment, please submit a product enhancement request using the form under Quick links on the right of the community site to let our Product team know that you'd like to have this feature added to a future version of Smartsheet.
-
@reagan.cink @Shaine Greenwood You can validate form fields for certain inputs.
Text/Number column can be validated for number, percent, phone, email.
Contact column can be validated for email.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives