This is my feature request, I think that is what you need as well: Automation: Assign/change people-column based on another people column - Feature requests - monday Community Forum
This is my feature request, I think that is what you need as well: Automation: Assign/change people-column based on another people column - Feature requests - monday Community Forum