I see there’s already an idea requesting a "Number only" column type, and I’d like to suggest adding a "Currency only" column type as well.
Currently, I have to create several workarounds to validate certain fields we collect. For example:
- Ticket number or Purchase Order number fields should only allow numbers and have a specific character length.
- Currency-related fields (e.g., costs, prices) often need validation for decimal separators. Even with formulas to check for commas or dots, users sometimes enter values with more than one separator (e.g.,
1.234,56 or 1,234.56), which causes sum or multiplication formulas to fail, as shown in the example below.
With the current Text/Number column type, it’s not possible to prevent invalid input before submission. We can only act afterwards, for example, through workflows or conditional formatting. This creates extra validation steps, slows down processes, and generates avoidable questions.
Adding dedicated Number-only and currency-only column types would prevent these issues upfront, making data entry faster, cleaner, and more reliable.
———
Link to the Numbers only column idea: https://community.smartsheet.com/discussion/100732/numbers-only-column
———
# column types – data validation – data entry validation – number column – currency column – numeric field – currency field – decimal separator – input restrictions – prevent invalid data #
