We need to monitor ongoing cases between several buildings. When I receive information from the state it would be easy enough to paste a new row (Preferably at the top of my master spreadsheet) with all of the information.
Intending to use
=filter(importrange(“[url]”,”Paste!$A:$ah”),Regexmatch(importrange(“[url]”,”Paste!$b:$b”),”Harrisonburg”))
as a way for each different building to access those items in my master list for the org.
However, this does not seem to update as I add a new row to the top of the table. The Filter command only accesses those rows that were originally a part of the source data.
What other options would I have so I could have one org spreadsheet with everything, and each of the other eight spreadsheets continually update with their information based upon a filter of one field?
Brian Nussbaum is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.