The Add-on installs all of the released formulas made by Top Contributors, like the MATRIX, SQLJOINS and CONSTANTS formulas. The formulas themselves use only JavaScript to perform their magic in presenting the result and no service is evoked (like the SpreadsheetApp) during operation which (in many cases) leads to a shorter processing time.
By:
Works with:
56K+
Overview
The Add-on installs all of the released formulas made by Top Contributors, like 

- MATRIX, SQLJOINS, CONSTANTS
- ROWTOTALS, UTILITIES, BRAILLE, MORSE
- JAVASCRIP, JS_MAP, JS_SORT, LEVENSHTEIN DISTANCE


Except for the UTILITIES, the formulas themselves use only JavaScript to perform their magic in presenting the result and no service is evoked during operation which (in many cases) leads to a shorter processing time.
Additional information
PricingNot available
Developer
Trader status unspecified
SupportNot available
Privacy policy
Terms of service
ReportFlag as inappropriate
Formulas by Top Contributors will ask for the permissions shown below. Learn more
Formulas by Top Contributors will need access to your Google account
This will allow Formulas by Top Contributors to :
See, edit, create, and delete all your Google Sheets spreadsheets
Display and run third-party web content in prompts and sidebars inside Google applications
See your primary Google Account email address
See your personal info, including any personal info you've made publicly available
Reviews
Language:
Sort by:
Google doesn't verify reviews or ratings. Learn more about reviews
Profile Picture
Mark Glover
February 22, 2022
These are great when they work, but very frustrating when they don't. E.g. =UTIL_SHEETNAME() function normally works when it is entered, but won't update when the sheet name changes. If the formula is entered again after changing the sheet name, it normally updates, but not always. Once it refuses to update, there seems to be nothing that can be done as a work-around.
Is this review helpful?
Yes
No
Profile Picture
Chance Freeze
October 30, 2021
Is there a way to make the utilities dynamic? I'm using UTIL_VALUESHEETS which is working great, except once it gathers the data it never refreshes. How can this be fixed? Great tools once I get this figured out
Is this review helpful?
Yes
No
Profile Picture
Geovany Kelly
November 16, 2020
Formula works perfect, and I am using it to built a big query Sheet used for report / charts. The thing is that everytime a change is made in the original sheets, the query reload everything, not bad so far .. but if that query Sheet I use it with Data Studio, it get stuck ... and I need to open the spreasheet in order that the fuction runs correctly, after that, the reports / charts work good. Could the developer give it a look? I mean the formula is just awesome!
Is this review helpful?
Yes
No
Profile Picture
Slava Dobromyslov
April 3, 2021
SQLCROSSJOIN does not work with open ranges e.g. Sheet1!A1:A. Looks like it tries to cross join all empty rows. As a workaround I have to explicitly specify last row of the range like Sheet1!A1:A10
Is this review helpful?
Yes
No
Profile Picture
Flojito Stillnet
September 21, 2020
Great Add-On, with ton of formulas very helpful. Must have if you don't want to use javascript and want more useful formulas out of the box. Thanks for the great job !
Is this review helpful?
Yes
No
Profile Picture
RDC Concrete
November 9, 2020
Suddenly, sometimes the commands stop working, and we have to wait for hours together, while we just see 'loading.... ' In the cell the command is typed in.
Is this review helpful?
Yes
No
Profile Picture
Rob Barreca
November 11, 2020
The JOINS are working great so far, I've been searching for this functionality for a long time!!!
Is this review helpful?
Yes
No
Profile Picture
Cadmus Tay
June 20, 2022
The letter "X" seem strange in Braille.
Is this review helpful?
Yes
No
Profile Picture
Zhouxun Yu
January 23, 2021
love the sql join function!
Is this review helpful?
Yes
No
Profile Picture
Mitthu Dehti wala MDTV (Md moidurrahaman)
September 12, 2020
Good
Is this review helpful?
Yes
No
1-10 of 12
Search
Clear search
Close search
Google apps
Main menu