I have a google sheet that uses this formula to organize my roster into groups,
=FILTER(IMPORTRANGE("SHEET_URL","Ranks!A:O") , MATCH(IMPORTRANGE("SHEET_URL","Ranks!D:D") , {"Civilian Manager", "Civilian Supervisor", "Trusted Civilian", "Civilian III", "Civilian II", "Civilian I", "Probationary"}, 0) = MATCH(IMPORTRANGE("SHEET_URL","Ranks!Q1") , {"Civilian Manager", "Civilian Supervisor", "Trusted Civilian", "Civilian III", "Civilian II", "Civilian I", "Probationary"}, 0))
This works however, when I have data in the cells it is using it gives me an error. I would just like to overwrite the cells instead of it giving the error.