Reputation
630
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
1 10 24
Newest
 Custodian
Impact
~60k people reached

  • 0 posts edited
  • 0 helpful flags
  • 39 votes cast
Feb
4
comment Google Sheets - how to VLOOKUP in a QUERY
sorry to bother you (again), but what if I need to filter also by "type of client" (just saying)?
Feb
4
accepted Google Sheets - how to VLOOKUP in a QUERY
Feb
4
comment Google Sheets - how to VLOOKUP in a QUERY
thanks!! I'm constantly dealing with problems like this, do you know of any tutorial on Google query language?
Feb
4
asked Google Sheets - how to VLOOKUP in a QUERY
Jan
19
accepted Google spreadsheet - QUERY changes time format
Jan
19
asked Google spreadsheet - QUERY changes time format
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