This article contains frequently asked questions that arise when using the Google Sheets Add-on. You can quickly navigate to a particular FAQ by using the table of contents below.
If I share my sheet with someone will they be able to update/edit my formulas?
Can I give my client or colleague access to the sidebar?
If I add my client as a user, will they have access to all my data?
I’m trying to insert a formula and I’m getting an error that I’m not logged in. What do I do?
If I share my sheet with someone will they be able to update/edit my formulas?
No, only the person who originally inserts a formula can change it. Likewise, only that person can run a manual refresh on that data.
Can I give my client or colleague access to the sidebar?
Yes, you can add your client or colleague as a user in your instance. You must go into the TapClicks app and add them as a user in the User menu.
If I add my client as a user, will they have access to all my data?
No, the data a user sees is governed by the data profile they are associated with. User can only access data they are provisioned to.
I’m trying to insert a formula and I’m getting an error that I’m not logged in. What do I do?
The owner must have the Google Sheet Add-on installed in order for the sheet to acknowledge the TapClicks custom function. If the owner of the sheet does not have the add-on installed and you do, you will get an error.