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.