I need to check if a column (type Number) is an Integer (no decimal).
I added this formula to the list validation:


But I get this error:

The formula contains a syntax error or is not supported.

2 Answers 2


Maybe your separator is not "," but ";". It depends on the regional settings. You can try your formula like this


Hope that helps.


You can try the following formula:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.