App Icon
madebytopcontributors
•  26,183
Overview
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.
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.
Reviews
Language:
Sort by:
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
Profile Picture
Zhouxun Yu
January 23, 2021
love the sql join function!
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
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
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 Pciture
Bill Korbholz
January 9, 2021
Same problem. I have the add-on installed as a domain app. This behavior, of either not finding the function, or Loading... forever, just started happening for me this month. In some cases, closing and reopening the spreadsheet resolves it. In other cases, I'm stuck with no obvious remedy.
Profile Pciture
Geovany Kelly
November 16, 2020
it also happpens to me, what I do is just refresh the spreadsheet and boom. But I am facing a major problem, I have the gSheet connected to Data Studio...it has been a headche, I need to be openning the gSheet everytime the query get stuck. :/
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
Mitthu Dehti wala
September 12, 2020
Good
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
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
1-9 of 9
Additional information
madebytopcontributors
Terms of Service
Search
Clear search
Close search
Google apps
Main menu