I have a complicated spreadsheet with multiple tabs that filter for various things. The raw data comes from a file that I must download as a .csv file each day. Looking for a way to simplify a bit.
=filter(importrange("https://docs.google.com/spreadsheets/...60","Data!$A:$FH"),IF(REGEXMATCH(Temp!CP:CP, "Read"), 1, 0))
this formula works fine. The problem is that I would need to update that URL each day on multiple sheets.
I was hoping to be able to just paste the URL into a separate tab, and have importrange look at that cell to find the URL.
I was hoping that I could do something like this:
=filter(importrange(**School Sheets!$I$4**,"Data!$A:$FH"),IF(REGEXMATCH(Temp!CP:CP, "Read"), 1, 0))
'School Sheets!$I$4' refers to the location on a different tab within this workbook where I would update the URL of the raw data each day.
That does not seem to be working.