I am trying to assign people to national holidays based on their location for resourcing purposes.
I have two relevant boards:
- A board that contains all my resources, including a Person column and a Location column (currently as a dropdown)
- Another board containing the national holidays for our different geographic locations with a dropdown column for location.
What I want to do is; say I create a person in the first board. We’ll call him Jim. Jim is located in USA. I would like to automate the flow so when I choose USA in the dropdown of the first board, Jim is automatically assigned to all holidays that contain USA in the dropdown column in the second board.
I’ve tried connecting the two boards using a mirror column, but I can’t quite get it right. Any ideas?