Hi Team!
I know the subject line is kinda obscure so I will give a quick context:
Here's my concern:
All options from Field 2 are correct except HR Learning & Development that belongs to another Group.
Here's the mapping of my table:
Here's the formula for New Department:
Select(Key to Group[Department],([Group]=[_THISROW].[New Group]))
I am wondering why that one department, that shouldn't be there, is appearing in the New Department field's options.
Any help would be much appreciated.
Thanks!
User | Count |
---|---|
15 | |
12 | |
9 | |
8 | |
4 |