Google Sheets: Hide 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:
docs.google.co...
Formulas:
docs.google.co...
Middle:
docs.google.co...
Connect with me:
• [e-mail]
• spencerfarris.me
• www.linkedin.com/in/spencer-farris/
• Twitter @FarrisSpencer
• Google Product Expert support.google.com/docs/profile/12305
Donate on Paypal: [e-mail]

[@__-...CL...-__]

Is there a way to connect a server calculator sheet to a client one with only importrange ? The question is: if the user wants to customize some values (inser own variable values for example), is there a way to not to collect in the server spread the users live datas changes that are calculated in server? The server: has the calculation logics and formulas that sends result to the client. The server also has the inputed users datas to manage calculation but i don't wanna collect that....if i want to give to a customer that client spread I would that the client insert own values, receive realtime calculation from server without sending to the server that datas.... But only get back the formula string to apply it in the client spread...

[@SnugJoiner]

Clever abstraction. Thanks for the help!

[@SpencerFarris]

Glad it helped!

[@silvestrecamposano6317]

Thank you very much Sir!... I have been looking for this techniques.... 😮❤...

[@SpencerFarris]

Most welcome! So glad it's helped

[@JorneRichard]

Super useful!!!

[@SpencerFarris]

Thanks!

[@CharlesShafer-x6k]

If I wanted to create a google sheet template to sell, would I have to create unique source/formula sheets for each customer, or is there a way to create one formula sheet, and sell the one source sheet?

[@SpencerFarris]

I have no idea about selling sheets

[@matteomaurizio9570]

Thanks Spencer for this interesting tutorial. I would like to understand if it is possible to apply a variant to the solution indicated that can be fine but unfortunately if a user A compiles the data and in the meantime also a user B and a User C are doing it none of them will achieve the correct result because each one changes the data and other people's results making the calculator unreliable. Here is what I want to achieve; After creating the three sheets Formulas, Middle and Source 1) share the Source Sheet with the final option in the url "/ copy" to force the recipient to create a copy of the sheet 2) the user who receives the copy with editor permission, as in your example, will be able to edit the sheet by entering values ​​or selecting values ​​from the drop-down menus 3) through the IMPORTRANGE function the sheet secretly takes the formulas from the sheet I HAVE NOT SHARED "Formulas" 4) using the formulas to import, process the data in your own sheet leaving intact the Source sheet and the Middle sheet and the original Formulas sheet without modifying any data Basically it should work as a calculator for which the formulas remain hidden and not interceptible. I also take this opportunity to ask you if it is possible to make sure that a website can use the sheet as an engine to process answers always leaving the original sheets intact. Thank you

[@SpencerFarris]

Sorry it's been SO LONG. Do you still need help?

[@educationvilla]

I have two sheets shared with my editor and iam owner of the sheet One sheet is unlock and other one is locked for editor is it possible to lock anather sheet for editor by script, as a run script on behalf of owner so that owner can make editor viewer till data entry from sheet one to other and then again editor to viewer after data entry is completed Plz guide

[@SpencerFarris]

I apologize I don't understand the setup/desire. Can you email me? [e-mail]

[@edmarocampo3910]

is it possible for others to hack the my google sheet if they have the shorten URL?

[@SpencerFarris]

I've never heard of a sheet getting hacked

[@edmarocampo3910]

@@SpencerFarris Thank you so much! I'm worried because I apply import range on my g sheet.

[@TrenerZvezdnaia]

Best!!!

[@ViniciusDuarteLage]

Its interesting but you if go to B2 in source table you can see the middle-step ID. Editing de URL, you can go do middle-step table and repeating the previous step you can go to formula table. I know thats not gonna be a problem for most users but isnt a fail? Or am i miss something?

[@SpencerFarris]

That's only true if the middle-step sheet is shared with your users. In this setup you should only be sharing the Source sheet with users.

[@mohammedfarook5376]

How to Hide Formulas In Google Sheets

[@SpencerFarris]

what?