0

I am working on a validation to determine if a selected choice is okay based off a previous selected choice.

There are a number of categories (labeled 1 thru 13). Category #1 and Category #13 can have Type N selected. The other categories (2-12) can have any type (N, S, V, O).

Both the Category and Type are Choice columns.

Current formula:

=AND(OR([Category]=#1,[Category]=#13),[Platform Type]=N)

Q1: Can I even use a choice column data type in the validation formula?

Q2: If so, what syntax is incorrect in my formula that is preventing it from saving.

0

Try changing your formula into this:

=AND(OR([Category]="#1",[Category]="#13"),[Type]="N")

And to answer your additional questions:

  1. You can use choice columns in the validation formula
  2. You should just enclose the values you are comparing with in the double quotes.
  • I tried your suggested change and did not receive a syntax error, however, I received the following error One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas. – anonymous Mar 23 '18 at 19:41
  • Please try using the different name for the Type column (and update the formula accordingly). – Damjan Tomic Mar 23 '18 at 19:45
  • @cheshire Do you actually have a column named "Type". That's not a legal name. You should have seen this when you attempted to create the column: "The column name that you entered is already in use or reserved. Choose another name." – Mike Smith - MCT - MVP Mar 24 '18 at 3:21
  • @MikeSmith-MCT-MVP My column is actually 'Platform Type', I should've realized this is an important distinction. Sorry, was trying to keep the info as generic and unidentifiable as possible. Will update question. – anonymous Mar 26 '18 at 21:48

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.