8,353 reputation
62070
bio website jacobjantuinstra.nl
location Netherlands
age 40
visits member for 2 years, 1 month
seen 4 hours ago

Hi and welcome to my profile. I'm Jacob Jan Tuinstra, born in the northern part of the Netherlands. In my free time, I try to do as much coding in Google Apps Script as possible. See my website for snippets I've made available. See my Google+ profile for more info.

Achievements

First to earn the enter image description here badge for the tag
First to earn the enter image description here badge for the tag
First to earn the enter image description here badge for the tag
First to earn the enter image description here badge for first posts
First to earn the enter image description here badge for close votes

Stack Exchange

profile for Jacob Jan Tuinstra on Stack Exchange, a network of free, community-driven Q&A sites


1d
comment Search for value in another spreadsheet
Given the tags (see revision), I thought the OP had a Google Spreadsheet/Forms/Script in mind.
1d
comment Search for value in another spreadsheet
Pure Google Apps Script question are best asked on Stack Overflow.
Dec
11
comment Function to retrieve a subset of rows coming from another function in Google Sheets
Why don't you share a doc. This way perhaps I can alter the code....
Dec
11
comment Function to retrieve a subset of rows coming from another function in Google Sheets
Have you tried the INDEX() formula?
Dec
6
comment MATCH Function does not work
Was my answer of use?
Nov
27
comment How to get a value from column 'A' in every 30th row in Google Spreadsheet?
That's great. Why don't you edit my post?
Nov
25
comment How can I sort all worksheets in my Google spreadsheet on open?
@Sarah You're welcome !!
Nov
25
comment How Do You Replace a Formula With Its Result?
That's not possible in Google Spreadsheet. Only Google Apps Script and not VB.
Nov
21
comment Sum cells according to cell colour
Use this code @TomHorwood made: webapps.stackexchange.com/a/50568/29140
Nov
21
comment Trying to query one sheet to inform another
Why don't you share a doc with us?
Nov
20
comment Google Scripts : How to distinguish Empty cells from Zero
@phermous: Have you tried it?
Nov
20
comment Google Scripts : How to distinguish Empty cells from Zero
@Punchlinern Didn't know that...
Nov
19
comment Google Scripts : How to distinguish Empty cells from Zero
OP is after a script solution.
Nov
7
comment How do I strikethrough text in Gmail?
Even the link itself doesn't really give much information.
Nov
6
comment Repeat last action in Google Spreadsheets
+1; just checked and it works.
Nov
5
comment Duplicate then concatenate in Google Spreadsheets
@jason_cant_code How about this?
Nov
3
comment In Google Spreadsheet, how to left align currency symbol but right align number?
Perhaps this can shed a light: webapps.stackexchange.com/a/42644/29140
Oct
28
comment URL to create a new Google document
The docs.google isn't outdated, it still works.
Oct
28
comment Is it possible to link a cell in Google Spreadsheets to a Google text document? (not spreadsheets)
-1; This for sure isn't the solution the OP asks for, as it opens the document.
Oct
27
comment How to extract IP address of the host into a row?
See: webapps.stackexchange.com/a/68989/29140