I want to use a mirrored board like a vlookup from another board, since it looks like vlookup is not currently supported in the formula columns. So, I am trying to get my board to automatically look for the name of a person in two boards, and mirror the value, rather than having to manually do all of that myself. Is there a way to do this? Most of the connected boards automations seem to create a new line, but that is not what I am trying to do, so any help would be appreciated. Thanks!
To better explain:
Board 1:
Working board that will have requests and a person attached to the request. I want to make sure that each person automatically has their ID in another column. Normally, I would use another excel page as a reference and vlookup off of that to do this.
Board 2:
Reference board.
Has every person’s name and ID. I do not want this board to change at all, just to be used to pull the ID when a person is selected for an item in Board 1.