2

I need to add validation on a numeric column. An error should be when the user fills the control with a decimal number using a comma instead of a dot.

I have a formula which looks like this:

=AND(IF(ISERROR(FIND(",", MyNumericColumn)),TRUE))

And it doesn't work. But if I change the character to a dot".", it will find it correctly. Any ideas how to add validation on comma?

0

As per my test, I am not able to find the comma (,) in number column using SharePoint formulas. So, it is difficult to add such validations.

Workaround:

Use single line of text field instead of number column & use below column validation:

=ISNumber([MyColumnName] + 0)
1
  • Unfortunately, this workaround will not work for me. Changing the column type involves a major rebuilding. This column has to be numeric.
    – Karolina
    Apr 30 at 7:59

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.