We are trying to link a few records between 2 different project bases and we hope that you can show us the right direction.
Problem Statement: We have 2 Project Bases, External and Internal, and we would like to add the records in External Base to another table in Internal Base.
Progress so far: We can sync all records from Table 2 in one base to another base with no problem.
Help Needed: Can we do a formula or rule set to add records from synced table to the another table in the same base ( Vlookup)?
We would really appreciate your thoughts and guidance on this one.
Thanks in advance.