Question 1

Why am I getting an error when I try to run trace precedents or trace dependents?

Accepted Answer

This answer assumes you are using Google Chrome as your browser, as we do not support any other browser. Additionally, it assumes you are able to install SheetWhiz and log into the app, but receive the following error when you try to run trace precedents or trace dependents:
Permissions Not Granted - OAuth2 request failed: Service responded with error: 'Service has been disabled for this account.'
The reason for this is because your Google Workspace account has restricted access to Google Drive and you or your IT team will need to designate SheetWhiz as a "Trusted" app.

You can verify whether your Workspace has restricted access to Google Drive by logging into the Admin Console of your Google Workspace Account. Note, you will not be able to do this unless you are an administrator.

Click Security > Access and data control > API Controls then click Manage Google Services when on the page. If Google Drive has been restricted, you will see "Restricted" in the Access column in the Drive services row.

https://static.wixstatic.com/media/07a3e8_ddbe95118cc545228c36cda170760987~mv2.png

This is a fine and likely prudent security policy, but it does mean that you will need to designate SheetWhiz as a "Trusted" app in order to run trace precedents and trace dependents. We need access to Google Drive in order to properly calculate your precedents and dependents and return them to you (and only you).

Note, there is no mechanism in place for anyone at SheetWhiz to view, store or otherwise interact with any of your data in your sheets. You can learn more about our security and compliance policies and our commitment to protecting your information at https://www.sheetwhiz.com/security (https://www.sheetwhiz.com/security)

In order to designate SheetWhiz as a "Trusted" app, you will need to again go to Security > Access and data control > API Controls but now click Manage Third-Party App Access

https://static.wixstatic.com/media/07a3e8_f5fe88f6811b46c990adeabcecc7c765~mv2.png

You will see a list of "Configured apps". The SheetWhiz app should be there. If it isn't, you can add it by clicking on "Add app" and looking us up by our name "SheetWhiz" or by our Client ID: 509120768285-n7c0agvmbfs5vum2kfiu048stfsd44u9.apps.googleusercontent.com (http://509120768285-n7c0agvmbfs5vum2kfiu048stfsd44u9.apps.googleusercontent.com/)(note this is updated from the old Client ID)

https://static.wixstatic.com/media/07a3e8_2526a6d977ca4f57bcdcf99c07deae07~mv2.png

Our app will be a Verified app. Verified apps have been reviewed by Google to ensure compliance with certain security and privacy requirements. Learn more about verified apps here (https://support.google.com/a/answer/9987046?hl=en)

https://static.wixstatic.com/media/07a3e8_f0ebad45ce23454c94fdaff6bf20ad5c~mv2.png

Once the app has been added, hover over the row and click "Change access"

https://static.wixstatic.com/media/07a3e8_198cd03a0feb4f7d96362572c10bb25b~mv2.png

From there, you will choose who to configure access for. After hitting "Next", you will be asked what type of access SheetWhiz should have. Click "Trusted" and then click "Next" in the lower right corner. Learn more about app access here (https://apps.google.com/supportwidget/articlehome?hl=en&article_url=https%3A%2F%2Fsupport.google.com%2Fa%2Fanswer%2F7281227%3Fhl%3Den&assistant_event=welcome&assistant_id=mdmbot&product_context=7281227&product_name=UnuFlow&trigger_context=a&fragment=reviewapps)

https://static.wixstatic.com/media/07a3e8_aba2639e718c4037b25340ef01559aaa~mv2.png

On the next page, click "Change Access" to save your changes.

https://static.wixstatic.com/media/07a3e8_f66d3d01210a4a10a8c52b784a89610f~mv2.png

Once done, you should refresh the SheetWhiz app either by logging out and then logging back into the tool or by removing it and reinstalling it from the Chrome Web Store (https://chromewebstore.google.com/detail/google-sheets-excel-short/bfncmfmdadhimlnpeecppaimgmeeppan?hl=en)

https://static.wixstatic.com/media/07a3e8_dc296a8f7a164c12b13fc57aa015e2a1~mv2.png

Run trace precedents or dependents again. If you are still receiving an error contact us by emailing david@sheetwhiz.com or submitting a form via our Contact Us (https://www.sheetwhiz.com/contact-us)page

Question 2

Why am I getting "Your admin has blocked this item" when trying to install SheetWhiz?

Accepted Answer

This answer addresses the below error that you receive when trying to install the SheetWhiz Chrome extension

Your admin has blocked this item (ID: bfncmfmdadhimlnpeecppaimgmeeppan)
https://static.wixstatic.com/media/07a3e8_9406c0db43274674be01a76fa77d3059~mv2.png

The reason for the error is because your device is managed by an organization that has likely disabled installation of any non-authorized extensions. You can verify this by clicking on the three dots in the Google Chrome browser and if you scroll to the bottom, you should see something along the lines of “Managed by your organization”. In this case, it says “Managed by sheetwhiz.com”(http://sheetwhiz.com/) but on a PC, it says “Managed by your organization”

https://static.wixstatic.com/media/07a3e8_95d9e3dffdf940b3bdcb4dc52a137735~mv2.png
Now that this is confirmed, you’ll need to get in contact with the administrator of your Google Workspace policy to get them to add SheetWhiz to their allowlist (and if it isn’t, contact us via chat or at info@sheetwhiz.com (mailto:info@sheetwhiz.com)for additional support). Note, there may be additional security questions for us to answer before your team is willing to do this. If this is the case, please send them our way and we can help with this. You can also answer many of these questions yourself by visiting https://www.sheetwhiz.com/security (https://www.sheetwhiz.com/security)

In order for your admin to add us to their allowlist:

1. In your Google Admin console (at admin.google.com)...

2. Go to  Menu  Devices > Chrome > Apps & extensions > Users & browsers.(https://admin.google.com/ac/chrome/apps/user) If you signed up for Chrome Browser Cloud Management, go to Menu  Chrome browser > Apps & extensions > Users & browsers(https://admin.google.com/ac/chrome/apps/user)

3. Select who you want to assign SheetWhiz to - the organization, a group that you've defined or an individual user. Here we're going with the whole organization because we want everyone at SheetWhiz to be able to use the tool
https://static.wixstatic.com/media/07a3e8_1a01a9a3cb7d4519972b64214b500b4d~mv2.png
4. Look in the lower right corner for a "+" button. Hover over it and then click on the lowest small circle that appears after you hover over the "+" button. This button will have the Chrome logo and will read "Add from Chrome Web Store" when you hover over it. This means you are about to add an extension from the Chrome Web Store (i.e., SheetWhiz) to your allowlist 
https://static.wixstatic.com/media/07a3e8_d34a7beb52c049c1b4a63bc89ffa4a88~mv2.png

5. The Chrome Web Store will pop up. Put in our extension ID in the Search bar in the upper left. Our ID is: bfncmfmdadhimlnpeecppaimgmeeppan

A direct link to our tool is here (https://chromewebstore.google.com/detail/google-sheets-excel-short/bfncmfmdadhimlnpeecppaimgmeeppan?hl=en)

https://static.wixstatic.com/media/07a3e8_5d4ac4d18772455789b24a41c8e6172d~mv2.png

6. Click on the SheetWhiz Chrome extension and hit "Select" in the upper right corner. This will add the extension to the allowlist

https://static.wixstatic.com/media/07a3e8_ccdfce497d4249ad966e9645616494ec~mv2.png

7. That's it! SheetWhiz is now added to your allowlist and the users who the policy applies to should now be able to access the tool

https://static.wixstatic.com/media/07a3e8_efce0617de3c4d0ca163c1c151704a7c~mv2.png

Question 3

Why am I getting an error when I try to login?

Accepted Answer

This answer assumes you are using Google Chrome as your browser, as we do not support any other browser, and you are receiving the following error when attempting to login to SheetWhiz, such as by clicking the "Continue with Google" button in the menu
OAuth2 request failed: Service responded with error: 'Service has been disabled for this account.'
The reason for this is because your Google Workspace account has restricted access to Google Drive and you or your IT team will need to designate SheetWhiz as a "Trusted" app.

You can verify whether your Workspace has restricted access to Google Drive by logging into the Admin Console of your Google Workspace Account. Note, you will not be able to do this unless you are an administrator.

Click Security > Access and data control > API Controls then click Manage Google Services when on the page. If Google Drive has been restricted, you will see "Restricted" in the Access column in the Drive services row.

https://static.wixstatic.com/media/07a3e8_ddbe95118cc545228c36cda170760987~mv2.png

This is a fine and likely prudent security policy, but it does mean that you will need to designate SheetWhiz as a "Trusted" app in order to run trace precedents and trace dependents. We need access to Google Drive in order to properly calculate your precedents and dependents and return them to you (and only you).

Note, there is no mechanism in place for anyone at SheetWhiz to view, store or otherwise interact with any of your data in your sheets. You can learn more about our security and compliance policies and our commitment to protecting your information at https://www.sheetwhiz.com/security (https://www.sheetwhiz.com/security)

In order to designate SheetWhiz as a "Trusted" app, you will need to again go to Security > Access and data control > API Controls but now click Manage Third-Party App Access

https://static.wixstatic.com/media/07a3e8_f5fe88f6811b46c990adeabcecc7c765~mv2.png

You will see a list of "Configured apps". The SheetWhiz app should be there. If it isn't, you can add it by clicking on "Add app" and looking us up by our name "SheetWhiz" or by our Client ID: 509120768285-e3vcat8ls615dtba8b7u76am7v1onn92.apps.googleusercontent.com (509120768285-e3vcat8ls615dtba8b7u76am7v1onn92.apps.googleusercontent.com)

https://static.wixstatic.com/media/07a3e8_2526a6d977ca4f57bcdcf99c07deae07~mv2.png

Once the app has been added, hover over the row and click "Change access"

Our app will be a Verified app. Verified apps have been reviewed by Google to ensure compliance with certain security and privacy requirements. Learn more about verified apps here (https://support.google.com/a/answer/9987046?hl=en)

https://static.wixstatic.com/media/07a3e8_198cd03a0feb4f7d96362572c10bb25b~mv2.png

From there, you will choose who to configure access for. After hitting "Next", you will be asked what type of access SheetWhiz should have. Click "Trusted" and then "Next" and then "Change Access" on the following page.

Learn more about app access here (https://apps.google.com/supportwidget/articlehome?hl=en&article_url=https%3A%2F%2Fsupport.google.com%2Fa%2Fanswer%2F7281227%3Fhl%3Den&assistant_event=welcome&assistant_id=mdmbot&product_context=7281227&product_name=UnuFlow&trigger_context=a&fragment=reviewapps)

https://static.wixstatic.com/media/07a3e8_aba2639e718c4037b25340ef01559aaa~mv2.png

Once done, you should refresh the SheetWhiz app either by logging out and then logging back into the tool or by removing it and reinstalling it from the Chrome Web Store (https://chromewebstore.google.com/detail/google-sheets-excel-short/bfncmfmdadhimlnpeecppaimgmeeppan?hl=en)

https://static.wixstatic.com/media/07a3e8_dc296a8f7a164c12b13fc57aa015e2a1~mv2.png

Run trace precedents or dependents again. If you are still receiving an error contact us by emailing david@sheetwhiz.com or submitting a form via our Contact Us (https://www.sheetwhiz.com/contact-us)page

Question 4

I'm pressing the shortcuts but nothing is triggering - why is this?

Accepted Answer

First, make sure you're pressing the rights keys relating to a shortcut. You can do this by clicking the SheetWhiz logo in the upper right corner of your spreadsheet to bring up the SheetWhiz menu.

https://static.wixstatic.com/media/07a3e8_69d2bd5a775d4910ad924967f6857821~mv2.png

If you don't see the logo, it's because your Google Workspace has not enabled SheetWhiz access and you should contact us to resolve. You can do this by emailing david@sheetwhiz.com (david@sheetwhiz.com)

Assuming you are able to click on the logo to bring up the menu bar, you should see a list of shortcuts that you can try.

https://static.wixstatic.com/media/07a3e8_808185f85e224618b38cc7c83e2ad63c~mv2.png

For shortcuts that begin with "Control" (i.e., "Ctrl" on a PC or "^" on a Mac), press all keys in the order listed and hold down until all keys have been pressed. For example, to insert a row using our default shortcuts, you would press "Control", then "Shift", then "+", holding all keys down

For shortcuts starting with "Alt" on a PC or "Option" on a Mac,  press and release all keys in the order listed. For example, if you are auto-fitting columns, you would hit "Alt" or "Option" (depending if on a PC or a Mac), release the key, then press "H". Release "H" then press "O". Release "O" then press "I".

You should press the keys consecutively within a couple seconds, otherwise the shortcut will not work.

Question 5

What browsers does SheetWhiz support?

Accepted Answer

We support Google Chrome officially and have also made improvements for Chrome-based browsers like Arc, Brave, and Island.

Question 6

How do I uninstall SheetWhiz?

Accepted Answer

You can uninstall SheetWhiz by navigating to our Chrome extension listing (https://chromewebstore.google.com/detail/google-sheets-excel-short/bfncmfmdadhimlnpeecppaimgmeeppan)and clicking the blue button that says "Remove from Chrome."

That said, before you go, definitely email us at david@sheetwhiz.com (david@sheetwhiz.com)with feedback - we definitely want to improve our extension and we are always building!
https://static.wixstatic.com/media/07a3e8_3e703b8e423648f4b099adebb5fd5d17~mv2.png