Hi! I’m building an app where the last dependent dropdown should return error if the value has been already used before. I’ve seen a way to prevent duplicates with list expressions but since it’s a dependent dropdown, it’s already using the ‘Valid_If’ field to reference another table. How can I accomplish setting a rule to invalidate values that have already been used?
The formula I’m using in Valid_If is: Base[Clave Participación (CP)]
Where ‘Base’ is the sheet refernced to filter this field (called simply ‘Clave’) based on the election on the previous column. And ‘Clave Participación (CP)’ is the unique value stored in the referenced table.
Thanks in advance