I have a simple table named "Admins" that has a field with the persons name and another field for which department they are in. I have another table named "Notifications" that depending on the type of notification it makes a list of which departments that should be notified. Here is an example
Event = New employee Notify = "Security, HR, Safety, IT"
My code looks like this
select(admins[email], [Department] = contains(notifications[notify dept], admins[Department]))
Code is good but doesn't return any results. Any ideas on how I can do this?
User | Count |
---|---|
15 | |
15 | |
8 | |
7 | |
4 |