I have the following code:


It's not working, can someone recommend a better formula.

Thank you!

The exact problem is... depending on the default site language the ; character needs to at times be , while at other times ;

I'm looking for a language agnostic formula that works with all site languages.


You can check that it should be "," instead of ";" in =ISNUMBER(FIND("@",[emailAddressField])) at Examples of common formulas and I think that something like calculated fields in SHarePoint are language agnostic for all.

Hope it'll help.

[Update] If you need validation you can here is an article how to use jquery input plugin. In that case user will have to put valid email address.

  • unfortunately they're not language agnostic. ; works in Czech site, while , works in an English site. Crazy I know.... – user879 Mar 22 '11 at 12:38
  • So you want to prevent user from entering wrong e-mail? Why not to use input mask in that case? – Andriy Shvay Mar 22 '11 at 12:50
  • I want to use validation on the column. So far we have a theory it is because SP uses Excel validation, and this is language dependent, the functions actually change depending on the language of the site. But its a theory at this stage. – user879 Mar 23 '11 at 12:46

I experienced the same problem, it IS language dependend, even the formula names change :-S. We circumvented this using jQuery: bind to the checkbox's onblur, if invalid, show message and disable ok button

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.