I have a table with 350 records (projects) and another table with about 200 records (clients). Is there a way to link a record in the projects table to a field in the client table without having to individually link 350 records to a specific record i...
Field 12 is the Client ID. I would love to just reference a Client ID in my project table, go out to look up that Client ID in my client table, and return an email, address, etc. The only way I see to do that is create Link column and then link a re...
But I still have to go to each cell and create the link to the correct record in the other table?
I have also used Smartsheet and it allows me to copy a formula down a column to do a VLOOKUP:
Thank you for that. But don’t I still have to go into each of 350 records individually and create the link? I am trying to avoid that and have the column automatically link to another table based on some criteria in the table I am linking from.
