526 reputation
821
bio website azist.com
location Buenos Aires, ARG
age 29
visits member for 2 years, 8 months
seen 2 days ago

fighting VS Google Apps


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
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