0

I am trying to set a validation setting to display an error message. I have a column Type set to choice (Radio buttons) with two options (No Time and Minutes), I have a further column MinutesSet set to number.

What I need is that if Minutes is selected from the Type choice the column MinutesSet must contain a number.

I would also like that if No Time is selected from the Type choice and the user enters a number in the MinutesSet column it will display error.

What would the formula be and should I just use the Validation in the Minutes column as this is available or should I use the Validation option in the generic settings?

0

Here is a sample formula you can use via List settings > Validation settings:

=IF([Type]="Minutes",NOT(ISBLANK([MinutesSet])),TRUE)
=IF([Type]="No Time",ISBLANK([MinutesSet]),TRUE)

Reference: IS functions.

0

You need to apply the following Form Validation to your list:

=IF(OR(AND(DataType="Minutes",MinuteSet>-1),AND(DataType="No Time",MinuteSet="")),TRUE,FALSE)

Note: Replace column names and values as per your list

enter image description here

1
  • Thanks for your help, this solved my query! Mar 3 at 7:41

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.