0

So far I manage to make a validation that makes the column only accept numbers:

=ISNUMBER([Column_Name]+0)

But I want users to be able to type ";" inside as column value so only numbers and semicolon allowed.

Anyone have any idea how I can manage that?

  • I don't think you can do this using OOTB column validation. Can you use javascript or .NET? – Erin L Mar 21 '16 at 15:15
  • @ErinL It does work will post the answer. – Rohander Mar 21 '16 at 15:31
1
=OR(ISNUMBER(FIND(";";[Column_Name]));ISNUMBER([Column_Name]+0))

Basicly FIND() will look for characters in the column and ISNUMBER() will be determine of FINDS true/false.

  • Column will accepts both numbers and ";".
  • This will also accept "a;3" – Erin L Mar 21 '16 at 16:51
  • If there is only one semi-column allowed, do a replace of the semi-colon with an empty string first then check for number..for multiple '; you have to nest some replaces. – Danny '365CSI' Engelman Mar 21 '16 at 19:56
  • @ErinL thats true :( – Rohander Mar 21 '16 at 23:21
  • @DannyEngelman Sadly it can exist unlimited of semi-column. If you know any good solution I would appreciate an answer to the question :) – Rohander Mar 21 '16 at 23:23
  • This can be done with javascript, or with third-party tools. If you can use javascript, let me know. I'll help get you started. – Erin L Mar 22 '16 at 13:06

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.