May i know what’s wrong with this formula under Valid_if?
NOT(In([_THIS], Slice Name [Column Name Not a Row Key]))
Im trying to achieve wherein the user cannot input duplicate value in a table slice . I understand I can simply use a row key. Unfortunately you can only use 1 column as a row key.
The formula above is working fine when adding new rows. The issue is when editing some columns on the Slice table the [Column Name Not a Row Key] is showing invalid.
Any advice how to achieve my goal?