Mirror Information From One Google Spreadsheet to Another
Episode 8: How to take information from one spreadsheet to another
Alice is from Fresno, California where she works for Fresno State University. She will show us how to up our game with Google Spreadsheets. Alice is a Google Certified Teacher from GTAWA.
Mirror information from one Google spreadsheet to another Google spreadsheet by using =importrange. Share a list of tasks that is always being updated or share a pivot table that only shows summary data and not the sensitive info you collected in the Form.