Import live data via IMPORTRANGE

Import the live metrics sheet from the marketing workbook into this dashboard. Pull the range Metrics!A1:E200 from the external workbook owned by Priya Sharma and place it onto a sheet named Live_Metrics using an import link so it updates automatically. Check permission errors, request view access from Priya if needed, and validate that headers align with our dashboard column order.

Before I add the marketing live sheet to the operations dashboard, make the imported data approval-ready. Highlight mismatched headers, spot missing rows or extra blank rows, surface any changes in column order since last import, and flag if the source uses merged cells or trimmed ranges that will break downstream lookups. Propose the minimal adjustments on either workbook to make the import robust.

I tried to load Metrics!A1:E200 from Priya’s marketing workbook and got a #REF error. I shared the target dashboard link with Priya and she confirmed she has view access. I don’t know if the sheet name changed, the range moved, or import permission wasn’t granted correctly. What exact checks should I run and what messages should I send Priya to fix this with least friction?