1

I have two columns that wish to validate on. Column A is a number field and Column B is a choice (drop-down) field. I wish to restrict the options that can be selected in Column B if the number entered in Column A is less than 8. Is this possible please?

1 Answer 1

1

Yes. This can be done something like below

=IF([ColumnA]<8, IF([ColumnB]='Option1', true, false), true)

If columnA value is less than 8 it check if columnB value is option1 then return true else return false else return true

Similarly you can nest all the other option values that need to be validated

4
  • That worked perfectly - a problem I have been unable to solve for the last 2 hours has now gone away. Thank you!
    – Dan Croft
    Oct 20, 2017 at 14:15
  • Glad to hear it worked! Oct 20, 2017 at 14:16
  • Mark his answer as correct if it worked for you
    – lazoDev
    Oct 20, 2017 at 14:57
  • Yes sir, sir. Or is it boss?
    – Dan Croft
    Oct 26, 2017 at 12:35

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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