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

  • 0 posts edited
  • 0 helpful flags
  • 36 votes cast
May
18
comment New Gmail contacts in Android
I guess I'll have to deal with all the contacts... thanks anyway!
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
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.
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
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
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?
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
15
comment Google Sheets - Auto update table and auto add new data entries
@JPV genius! Thank you!
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
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
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
22
comment Google spreadsheet sort auto update
@pnuts is gathered from another spreadsheets that my co-workers are filling, using IMPORTRANGE.
Aug
12
comment Repeat last action in Google Spreadsheets
exactly as Vidar said
Nov
4
comment How do I delete attachments, in bulk, from messages in Gmail?
I don't know exactly how to delete attachments and keep the messages, BUT you can use this service findbigmail.com that looks for big size attachments in your gmail account and you can delete the bigger ones. Hope this helps
May
5
comment Several Gmail accounts sharing one email address
exactly, we all CC the group address