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)