Reputation
600
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
9 22
Newest
 Yearling
Impact
~47k people reached

  • 0 posts edited
  • 0 helpful flags
  • 36 votes cast
Jan
19
comment Google spreadsheet query reference to several sheets
sorry, what I was actually asking is to reference that formula in "select Col1, sum (Col5) ... ETC", after the "query" part, is it clear??
Jan
16
comment Google spreadsheet query reference to several sheets
Is this wrong? =ArrayFormula({query(query({'SHEETNAME1'!A3:D,value('SHEETNAME2'!B3:B)}....ETC
Jan
16
comment Google spreadsheet query reference to several sheets
thanks again! I'll try it out later @ work
Jan
16
asked Google spreadsheet query reference to several sheets
Jan
15
comment Google Sheets - Auto update table and auto add new data entries
@JPV genius! Thank you!
Jan
15
accepted Google Sheets - Auto update table and auto add new data entries
Jan
15
revised Google Sheets - Auto update table and auto add new data entries
added 72 characters in body
Jan
14
comment Making Cognito form editable by submitter at later date
@pnuts totally, I get the point of the question. I just poset a quick workaround
Jan
14
answered Making Cognito form editable by submitter at later date
Jan
14
comment Automatically create a copy of gmail emails into a folder/label while leaving original in inbox
You can use the key "e" to archive messages
Jan
14
asked Google Sheets - Auto update table and auto add new data entries
Dec
22
awarded  Notable Question
Aug
23
comment Google spreadsheet sort auto update
I've moved the data to a hidden sheet and I only show the QUERY, Thanks!
Aug
23
accepted Google spreadsheet sort auto update
Aug
23
awarded  Curious
Aug
22
comment Google spreadsheet sort auto update
@pnuts is gathered from another spreadsheets that my co-workers are filling, using IMPORTRANGE.
Aug
22
asked Google spreadsheet sort auto update
Aug
12
comment Repeat last action in Google Spreadsheets
exactly as Vidar said
May
9
awarded  Yearling
Apr
25
awarded  Notable Question