I am currently using importrange and query functions to bring in data across cells in a Google Sheet. When I try to manually change a cell, I get the error that says the whole query or import range could not be expanded because it would overwrite my manual edit. What I want is to have the query or importrange bring in information but also be able to change individual cells if needed and I have not been able to find any documentation how/if this is possible? Any suggestions?
