Can anyone help me with a video answer to the following question?
I want to be able to enter something in one column and have the matching content from another board be entered in the corresponding cell of the current board, without having to repeat the content from the other board.
Let me explain with an example.
I have boards 111, 222, and 333 as shown in the attached image.
I want the data on board 222 and board 333 to automatically populate on board 111.
I type aa (in red) in Column 1 of board 111.
Then, I want to automatically extract the values in Column 2 and Column 3 of Item 2A from Board 222 that has aa in Column 1 and put them in Board 111.
In other words, I want bb and cc to be automatically entered in Column 2 and Column 3, respectively, of Board 111, which I have colored green.
How should I fill in Column 2 and Column 3 of Board 111 to make it work as above?
If I enter X (colored in red) in Column 10 of Board 111, I want to similarly have it automatically take the values Y, Z, which correspond to Column 20 and Column 30 of Item 3A on Board 333, and automatically populate them in Column 20 and Column 30 of Board 111 (colored in green), respectively.
Do I need to create column 20 and column 30 on board 111 to make this work as above?
If I do the above, if the contents of the columns on board 222 and board 333 change, will the contents of board 111 change automatically, and how do I make that happen?
If possible, I would appreciate it if you could do it in a video like LOOM.
Thank you.
