Pulling out data from a master sheet
I'm in need of a solution to track activities. There is a master sheet that I have view access to where items get added by different parties. I want to pull out data based on a filter to create a tracking tool to make sure that my tasks in relation to the tasks in the master sheet are completed. Think about reaching out to a client once we have a new date for a batch of product available. Therefore the product ID is stable but the batch numbers and dates are constantly being added or updated.
Normally in excel I'd use an Array formula or smart filtering to get the information but neither seem to be available in Smartsheets. Index-Match and Vlookup only deliver the first batch number. Simple cell linking is not sufficient as there are number of other items in the master sheet that I'm not interested in and I'm way over the 500 cell limit.
A report does not achieve my goal as I need to be able to add a date column and a check box to the data I pullout from the master sheet.
Does anyone have an idea of what I might try next?