Skip to main content
SharePoint

Return to Question

Tweeted twitter.com/StackSharePoint/status/865855495009165313
deleted 3 characters in body
Source Link
Mike
Mike
  • 12.2k
  • 8
  • 42
  • 64

I need to validate a Text field and ensure the number enter is anything between 0 and 7. I tried many options but can't get it. What syntax do i add to this to allow any number from 0 thru 7 to be entered? So far i have

=LEN([Scheduled Day]+1) +ISNUMBER([Scheduled Day]+0) =2

Thank you....

=LEN([Scheduled Day]+1)
+ISNUMBER([Scheduled Day]+0)
=2

I need to validate a Text field and ensure the number enter is anything between 0 and 7. I tried many options but can't get it. What syntax do i add to this to allow any number from 0 thru 7 to be entered? So far i have

=LEN([Scheduled Day]+1) +ISNUMBER([Scheduled Day]+0) =2

Thank you....

I need to validate a Text field and ensure the number enter is anything between 0 and 7. I tried many options but can't get it. What syntax do i add to this to allow any number from 0 thru 7 to be entered? So far i have

=LEN([Scheduled Day]+1)
+ISNUMBER([Scheduled Day]+0)
=2
Source Link
Rob A.
Rob A.
  • 33
  • 1
  • 3

SharePoint Field Validation less than or equal to 7

I need to validate a Text field and ensure the number enter is anything between 0 and 7. I tried many options but can't get it. What syntax do i add to this to allow any number from 0 thru 7 to be entered? So far i have

=LEN([Scheduled Day]+1) +ISNUMBER([Scheduled Day]+0) =2

Thank you....