Wednesday, July 25, 2018

SharePoint Column Validation - Is Numeric

Scenario
  • You want the Title field to be an integer only.
Issue
  • The Title field cannot be typed as an integer using the standard list administration UI
  • The column validation in SharePoint is not straightforward
    • ISNumeric([Column Name]) does not work as it always sees the parameter as text
      • You have to add 0 to get a numeric value
Resolution
  • Use this format for the column validation to correctly identify an Integer
    • =IFERROR(INT([Column Name]+0)=[Column Name]+0,FALSE)

No comments:

Post a Comment