Great going. I am also looking for the 'next step' - character/digit limits, custom pattern recognition, etc.
I've found that using the Number Only validation is problematic because it drops the leading zero when entered by the user. For a common example, the zip code for New Haven, CT gets typed in the form as 06511 but then the entry is saved as 6511 in the sheet. There are more examples than I can think of where admins want to restrict the form field to only contain numbers but a zero may be the first digit of a value.
@Matt Rasmussen The postal service should never have created any zip codes starting with a leading zero in the first place. What poor planning! But that's par for the course with USPS. I stopped using number only validation on zip code fields for this very reason.
Jeff Reisman, IT Business Analyst & Project Coordinator, Mitsubishi Electric Trane US
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Today I found that using "Number only" validation rounds decimal entries to the nearest tenth, so when I put 2.25 in the form, the sheet records it as 2.3:
Changing the validation to "Percentage" keeps the number entered on the form but it appends the % character, as seen in the third example above.
Is there a plan to validate that a number entry in the form is still a number but not round the value?
Validation is a great feature, but rounding is not helpful. This example is for time worked on a task, but we have also been using it for budget amounts, expenses, estimates, etc., and the rounding is causing more of an issue than people occasionally mistyping the wrong thing in the form that we were trying to prevent.
Hi Community, Previously, when adding a domain to manage in Admin Center, SysAdmins needed to take separate actions to register, validate and activate the domain. We streamlined this process, so now, SysAdmins can validate and activate their domains in a single step. As a reminder, domain management capabilities are…
Hi Community, We’re excited to announce that Bridge by Smartsheet has come to the Smartsheet EU region! Bridge by Smartsheet allows users to create custom process automation workflows with event and schedule-based triggers. Review our help article differences between the Bridge EU and US Smartsheet environments. Bridge is…
Hi Community, In this update, we're thrilled to introduce an intuitive interface for adding licenses to 29K bill-to customers. This enhancement simplifies the process, enabling you to scale your usage of Smartsheet without unnecessary complexities. No more delays, just immediate access to the licenses you need. Help…
©2023. All Rights Reserved Smartsheet Inc.