587 reputation
822
bio website azist.com
location Buenos Aires, ARG
age 30
visits member for 2 years, 10 months
seen Mar 24 at 0:47

fighting VS Google Apps


Mar
20
comment Repeat last action in Google Spreadsheets
@HighlyIrregular yep, it's working now, maybe I did something wrong:P
Mar
18
comment Repeat last action in Google Spreadsheets
I'm still getting the "There are no changes to redo." alert. I tried pressing F4 or CTRL+Y after inserting or removing a row
Mar
16
accepted Google Drive files not showing in Gmail search results
Mar
16
answered Google Drive files not showing in Gmail search results
Mar
16
comment Google Drive files not showing in Gmail search results
@w3d found it! is a Labs feature, I don't know why, suddenly, it was disabled, I turn it on again.
Mar
13
asked Google Drive files not showing in Gmail search results
Feb
19
comment Dynamic date range query
thanks, and why doesn't work If I just write: where A>=date 'A1' and A <= date 'B1'") . assuming that the user will always enter dates in A1 and B1
Feb
19
comment Dynamic date range query
can you explain a bit this part: '"&TEXT(A1,"yyyy-mm-dd")&"' . What are the & for? and the TEXT?
Feb
18
awarded  Informed
Feb
17
asked How to know email of a Gmail chat contact?
Feb
4
comment Google Sheets - how to VLOOKUP in a QUERY
haha just added another condition "where XXX and XXX" didn't know it was possible
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