Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have the following code:

=ISNUMBER(FIND("@";[emailAddressField]))

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.

share|improve this question

2 Answers 2

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.

share|improve this answer
    
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

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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