Skip to main content

Questions tagged [google-sheets-custom-function]

Use this tag for questions about custom functions in Google Sheets created by using Google Apps Script.

17 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3 votes
2 answers
90 views

Filter function with multiple variables google sheets

I want to be able to use a filter function for people in NAME whose P DATE is within a specified range. However, if they have a Y under VALIDATED, I want the filter to also include names with the T ...
Kyle's user avatar
  • 31
2 votes
1 answer
2k views

3D Formula Google Sheets - sum across sheets

I'm trying to script an equivalent to Excel 3D formula into Google sheets. I have a workbook with numerous worksheets and a master sheet that should sum up the data. In excel I would have used this 3D ...
Mady's user avatar
  • 21
1 vote
0 answers
186 views

In Google Apps Script, how do you get the Range of the calling cell in a custom function?

I'm trying to get a reference to the calling cell's range in a Google Sheets custom function. For example: function MyAddress() { callingRange = // get calling cell reference here return ...
Caleb McNevin's user avatar
1 vote
0 answers
537 views

Custom function on Google Sheets that can extract hyperlinks from formulated cells

I recently found this post, which is so close to my solution, but not quite there! Extract the link text and URL from a hyperlinked cell The issue with this custom formula (=LinkURL()) is that it ...
Jamie Johnson's user avatar
1 vote
1 answer
441 views

Copy formula every other row and every column

I have been playing with scripts to try and figure out this tedious task as there are 600ish rows in my sheet, times 4 sheets. So far I have come up with this function myFunction() { var ss =...
Nicholas Chauvin nxchauvin's user avatar
1 vote
1 answer
425 views

How to update this formula so it automatically updates?

It's come to my attention that GoogleClock no longer works on new sheets, anyway I can update the below code so it can update every minute: Tried put =SheetNames(NOW()) It says not allowed. I'm very ...
Chris 's user avatar
  • 11
1 vote
0 answers
30 views

How to Get Data from Multiple Cells and Combine into a Comment in another cell

I have a spreadsheet of orders (rows) that has room for 70 products (columns). I would like for a script to find every cell that has a value (0's are blank) and then write that value (this is the qty ...
Aaron's user avatar
  • 11
1 vote
1 answer
3k views

Is there a way to get MD5 Checksum from the files with a custom formula?

I have a Google Sheet full of important links to images on Google Drive. Is there a way to get MD5 Checksum from the files with a custom formula? Here is my scenario: No. | PHOTO | MD5 ...
GCC's user avatar
  • 11
0 votes
0 answers
47 views

How to parse multiple cells in one go using ImportJSON()?

I have a dataset with 14 columns. Two of the columns contain text that is in JSON format. I am currently parsing the data with ImportJSON(), a script that is a collection of custom functions. It has ...
Boris Fredoc's user avatar
0 votes
0 answers
98 views

Auto delete certain rows on the first of every month - Google Sheets

I've built a Sheet on Google Sheets with multiple tabs and formulas for me and my coworkers to use. Only thing I couldn't do is set a formula that deletes multiple specific custom cells on multiple ...
Tal's user avatar
  • 1
0 votes
0 answers
225 views

Multi-row dependent drop-down list stops working correctly when a row is inserted

Multi-row dependent drop-down list stops working correctly when a row is inserted. I think I need a script so that the drop-down options in column B, that change depending on what drop-down option is ...
user246475's user avatar
0 votes
1 answer
64 views

Creating a custom formula in Google Sheets without scripting, but instead based upon another sheet

Ive made a custom calculator in a google sheet, the calculator accepts 5 inputs (arguments) on row 1, rows 2-50 is where is runs the calculation, and the result comes out in row 51. This calculator ...
sam's user avatar
  • 6,979
0 votes
1 answer
3k views

Steam Webapi & Hours played for a specific game - Google Sheets

So I have managed to get a list of owned games and total hours in each game with =importJson. The only issue is I only want data for one game. The json query returns all owned games. The api wiki says ...
allahuakubah's user avatar
-1 votes
1 answer
19 views

Subtracting Amounts from Specific Categories

I'm working on trying to make a relatively simple spending tracker using Google Sheets. In this example, the person has $5000 already in the bank, and they have earned $1000. The categories of Housing,...
Hayden's user avatar
  • 1
-1 votes
2 answers
216 views

Empty cell reference when "Loading..."

I want to do a calculation with imported data from an HTML link. The data is imported every minute. There is loading time and this ensures that the cells are empty during loading. Because my formula ...
Coen17st's user avatar
-1 votes
2 answers
113 views

IF and THEN statements on spreadsheets using color

I am creating spreadsheets with multiple tabs for children to work through. To show they have completed each tab, when they have finished the work correctly I am using the following statements: =IF(...
Nick's user avatar
  • 1
-1 votes
1 answer
419 views

Google sheet - get crypto currency price from Cryptobridge Exchange API

How can I retrieve only the price from this API in a Google spreadsheet? This is the API ticker - https://api.crypto-bridge.org/api/v1/ticker For example, if I use this function =INDEX(IMPORTDATA(...
despes's user avatar
  • 1