Common setup issues

If AI for Sheets is not recognizing your plan, or formulas show errors, these are the most common fixes.

Start with your symptom

  • Unknown function (for example, Google Sheets can’t find =GEN): follow getting started to open Extensions > AI for Sheets > Use AI Formulas.
  • Upgrade prompt or plan not recognized: sign in with the Google account used for your subscription, then click Refresh in the Upgrade Account sidebar. See multiple-account help below.
  • Other formula errors: find your error in fix formula errors.

1) Sheet ownership mismatch

Problem: AI formulas use the plan of the sheet's owner. If someone else owns the sheet, formulas there use their plan, not yours, even with edit access.

Solution: Click File > Make a copy to create a copy under your subscribed account, then click Refresh in the Upgrade Account sidebar.

2) Multiple Google accounts logged in

Problem: Being signed into multiple Google accounts can confuse the add-on, causing it to not recognize your subscription.

Solution:

  • Sign out of all Google accounts.
  • Sign back in using only the email you used for your subscription.
  • Click Refresh in the Upgrade Account sidebar.

3) Organization admin restrictions

Unknown function error in Google Sheets

Problem: If your Google Workspace Admin has disabled Marketplace add-ons, AI for Sheets formulas may show errors like Unknown function.

Solution:

Google Admin Console Marketplace apps settings
  • Use your organization's approved account and access process. For subscription-account questions, email support@simplemetrics.xyz.

Still stuck?

Email support@simplemetrics.xyz and include a screenshot of the error plus the email you used to subscribe.

Was this page helpful?

Your feedback helps improve this content.