Error: #NAME?

Google Sheet cannot find Websheet AI formulas

Why did I see this error?

There are two reasons:
A. Websheet AI is not installed
B. Google Sheet bug

Below are instructions for both cases.

A. Installing Websheet AI

To stop seeing #NAME? issue—install websheet AI

1. Extensions → Add-ons → Manage add-ons

Find the Extension menu point at the top and launh Manage add-ons menu

This will open the add-ons menu

2. Find Websheet AI

In the add-ons menu, write “Websheet” to the search box

3. Click on the Websheet AI

Open Websheet AI page to install it

4. Install Websheet AI

Click on the install button, agree with all permissions because they are needed for work, and close the window

5. Refresh the page

Refresh (Crtl / ⌘ + F5) the browser tab to ensure that everything is fine

6. Extensions → Websheet AI → Start

Start the Websheet AI extension

B. Handling Google Sheet bug

If the Websheet AI is installed, but you still see the #NAME? error, then follow the instruction below

1. Extensions → Add-ons → Manage add-ons

Open Manage Add-on menu

2. Extensions → Add-ons → Manage add-ons

Open Manage Add-on menu

3. Three dot menu → Turn off Use in this document

In the extension options menu, uncheck Use in this document

4. Refresh the page

Refresh (Crtl / ⌘ + F5) the browser tab

5. Extensions → Add-ons → Manage add-ons

Start add-ons manager once again

6. Three dot menu → Turn off Use in this document

In the extension options menu, activate Use in this document

7. Refresh the page

Refresh (Crtl / ⌘ + F5) the browser tab

8. Extensions → Websheet AI → Start

Start the Websheet AI extension

Now everything should work!

Websheet AI is designed to empower you in crafting the perfect website effortlessly. Discover the myriad of options and bring your vision to life.