This is what I'd like to do:The public (even you!) would have view access to a particular Google sheet.  It would draw data from another Google sheet, which you DO NOT have any access to.  Using formulas I would filter out the non-public data in the public sheet.My understanding is that ImportRange will not let you reference a sheet you do not have direct access to, but I am no Google sheets wizard, there may be another way to accomplish my goals.This seems to be pretty close, still digesting how to implement it: https://stackoverflow.com/a/14558223/2589506Otherwise, I cannot have this automated, which would be lame.Thanks for the help!
Reference one sheet from another, where the user may not have view access to the referenced sheet
google spreadsheets;google apps