I have two sheets, both sheets have a row of column IDs, I would like to dynamically match the column ID from one sheet to the other sheet and then update a row. Similar to the new Lookup fucntion that was recently released but across two sheets. Has anyone developed a solution for this. My only option is to manually link the cells for over 3000 rows. I have also looked at one of the apps that integrate with Smartsheet to try and create a report but no luck so far.
