Syncing two Sheets, so when I pull a report - it pulls information on the same project from two diff
I'm trying to sync two sheets, so when I pull a report, it pulls information on the same project from two different sheets.
I have a unique identifier across two sheets. I've used data mesh to make sure the same unique identifier is being used across two sheets. Yet, when I pull a report SS thinks that Project 1 in Sheet A is different than Project 1 in Sheet B. How do I get the sheets to sync? That Project 1 in Sheet A is the same Project in Sheet B?