How to validate of cell repeated or not

hello my friends
Can i set a role for validation at entering data in a table ?
i have a table that contains promo- codes for a marketing department. Every promo code assigned for a section in sales department. it shouldn’t assign in the table for two sections in sales sales department. is there a role to validate if a colleague is entering a code in the table for department A, a role that says ‘this code is already used for department B’ ? is it available rather than the team filter on duplicates to resolve after that ?
thanks

This topic was automatically closed 15 days after the last reply. New replies are no longer allowed.