Conditional Import from "Master" Sheet
I have a "master" sheet called "Verified Content List." This sheet contains about 600 rows. Each row contains metadata for a specific assets. A column in that sheet called [Content Type] identifies each asset's type (e.g., Data Sheet, Ordering Guide, Battle Card, etc.) The list is updated once per week via Data Uploader as new assets are published and older assets are expired.
(Also, FWIW, each row on the Verified Content List is assigned a unique "lookup" number that never changes and numbers are not re-used once an asset expires.)
I have a second worksheet (called "Battle Card Curation Audit") where I want to isolate the assets with the [Content Type] of "Battle Card." I then have columns on this sheet where I can identify the specific competitors for which we have created and published a Battle Card.
I do not want to have to manually cut/paste the battle card assets from the Verified Content List, and I cannot create a report form the Verified Content List, because I cannot then add the needed data to track which competitors we've covered. I also cannot use a workflow to move or copy the battle card rows, because the columns between the Verified Content List and the Battle Card Curation Audit are NOT identical.
So, what I am looking for is a formula or conditional cell-linking process that will pull the Battle Cards from the Verified Content List to the Battle Card Curation Audit worksheet.
Help Article Resources
Check out the Formula Handbook template!