Hide Active Formulas with IMPORTRANGE

Using sets of IMPORTRANGE() formulas to hide the “live” formulas.

This may be done with 2 or 3 documents – 2 is simpler, 3 is more secure.

Source:
https://docs.google.com/spreadsheets/d/1WDjDm0EZV76Pxwx3qisOHuOYuP3Ctdlm4wxHoOl8pWs/edit#gid=0
Formulas:
https://docs.google.com/spreadsheets/d/15bxDakBx9rgRiws-NMTgmyGiKK-iYmm_YOkH2Ed5yjQ/edit#gid=0
Middle:
https://docs.google.com/spreadsheets/d/1i_Jaua74U7J6PVM5J-Th68CN6iObrfww0MEFshIosoU/edit#gid=0

Connect with me:
• spencer.farris@gmail.com
• spencerfarris.me
• www.linkedin.com/in/spencer-farris/
• Twitter @FarrisSpencer
• Google Product Expert support.google.com/docs/profile/12305

Donate on Paypal: spencer.farris@gmail.com

#GoogleSheets #GoogleAppsScript #appsscript

Leave a Reply

Your email address will not be published. Required fields are marked *