Beginner: query formula for Bar Chart in Google Sheets

😇 Here's the old tick I wanted to share. Copy Sample File! You could create any Chart with a single QUERY formula or combination of QUERY+FILTER+SORT+UNIQUE Here's the chart: The formula is: =QUERY({A:C},"select Col1, sum(Col3) where Col2 <> '' group by Col1 pivot Col2" {} — used to convert the range into the array. Now … Continue reading Beginner: query formula for Bar Chart in Google Sheets

Family Expenses App. Glideapps + Google Script. Part 2 of 2

This is the sequel, the original post is here:  Family Expenses App. Glideapps + Google Script. Part 1 of 2. Modify Finanso. Modification points are: Create your own user tabs (or one tab if you're single) Modify categories for your expenses. Lets' shortly recall the scheme: GlideApps Google-Apps-Script _______________^_______________ _________^_________ | | | | 📱Finanso … Continue reading Family Expenses App. Glideapps + Google Script. Part 2 of 2

Family Expenses App. Glideapps + Google Script. Part 1 of 2

👋 Greetings! I'm glad to share the app for family finances. Meet Finanso! Our family is happy using Finanso for 3 months so far. Finanso is powered by Glideapps. Glideapps = App+Sheets Glideapps ensures the data is synchronized between spreadsheets and the App. When I enter the data to my phone, I see it in … Continue reading Family Expenses App. Glideapps + Google Script. Part 1 of 2

Join Sheets, Jobs

This article is an answer to the comment by Luis Paliotes: Hello I was wondering, If it’s possible to build a Google Script that performs the same action as the following query: =query({IMPORTRANGE("SpreadsheetKey1","SheetName!A2:M"); IMPORTRANGE("SpreadsheetKey2","SheetName!A2:M")}, "SELECT Col1,Col6,Col4,Col5,Col8 WHERE Col5='Not Treated'") The problem I’m facing is that I am using this Query to connect 16 different Spreadsheets, … Continue reading Join Sheets, Jobs

Manager, Accountant, and Google Sheets

The case. Manager and Accountant Here's the Manager: Photo by Daria Nepriakhina on Unsplash She uses the phone to share photos on Facebook edit her Google Sheet with a purchases report. Here's the Accountant: Photo by Crew on Unsplash He's chatting with his girlfriend editing the main purchases report in his Google Spreadsheet. The Manager and the Accountant use different Google Spreadsheet files. … Continue reading Manager, Accountant, and Google Sheets

Upload image from your computer to Google Drive using HTML-form & Show image via URL (IMAGE function) in your Spreadsheet

Problem The user needs to show pictures: list products or see product design on the screen. The new Google Sheets feature — insert an image into a cell — works fine. The drawback of this method is that an image is actually saved into the file's body: you can't copy this image to the other … Continue reading Upload image from your computer to Google Drive using HTML-form & Show image via URL (IMAGE function) in your Spreadsheet