App Icon
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.
Works with:
27,804
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
SupportNot available
Privacy policy
Terms of service
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:
Profile Picture
Mitthu Dehti wala
September 12, 2020
Good
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
Zhouxun Yu
January 23, 2021
love the sql join function!
Is this review helpful?
Yes
No
Profile Picture
A User of Formulas by Top Contributors
April 24, 2020
I need step by step process on the program.
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
ProjectorRepair uk All about projectors
August 16, 2020
Super
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
Flo De Frocourt
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
Viacheslav 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
1-9 of 9
Search
Clear search
Close search
Google apps
Main menu