0


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

=mod([MyField],1)=0

But I get this error:

The formula contains a syntax error or is not supported.

0

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

=mod([MyField];1)<>0

Hope that helps.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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