Perfect quick and direct to the point presentation

@coupleracademy

3 ай бұрын

Glad you liked it! :)

THANK YOU SOOO MUCH! a paid Coursera course couldn't have explained it better!

@coupleracademy

3 ай бұрын

Thank you for such a lovely comment, we're so happy you enjoyed our content. Come back for more :)

Really nice rapid summary of how to use Query

@coupleracademy

5 ай бұрын

our pleasure, check out other vudeo tutorials on our channel, we cover different Google Sheets functions and mucn more!

Penjelasannya sangat mudah dimengerti, ringkas dan cepat. Channel rekomendasi untuk belajar lebih lanjut mengenai Google Sheets. Sangat mudah bagi saya untuk mengaplikasikannya, terima kasih banyak 😍👌👍

@coupleracademy

4 ай бұрын

Thank you! :)

Thank you

@coupleracademy

8 ай бұрын

you're welcome, check back for more interesting content soon :)

great tutorial. Can this be used in App script to fetch data and show the reports ?

@coupleracademy

Ай бұрын

Thanks for the great feedback! 😊 Yes, you can use the QUERY function in Google Apps Script to fetch data and generate reports. You'll use the SpreadsheetApp service to access your data and then apply the QUERY function to manipulate it. It's super handy for automating tasks and creating dynamic reports. If you need any help getting started, let us know!

to import from a different sheet if I need to select col A:D & column H how will go about it..apart from writing the column name like col1,col2 and so on

@coupleracademy

3 ай бұрын

Hi! The simplest way is to probably set as a range an array with all columns you want to fetch and then SELECT *, for example =QUERY({Sheet1!A1:D, Sheet1!H1:H}, "SELECT *")

Can we do the column concatenation in query and how

@coupleracademy

6 ай бұрын

Hi! Unfortunately QUERY doesn't support concatenation. You may need to use a workaround, maybe this one helps? stackoverflow.com/questions/42571114/how-to-use-concat-in-query

This is beautifully done but doesn't work for me and I can't figure out why... when I try to add the curly braces inside the query function, my version of google sheets auto add "ArrayFormula(" syntax to the beginning of the function and therefore ignores the semi-colons that combines data from multiple sheets. Any ideas on how to resolve?

@coupleracademy

5 ай бұрын

I haven't encountered such an issue with auto-adding an arrayformula function. However, you could try to specify the ranges first and then add curly braces to the formula. I hope this trick will help you resolve the issue.

Hi, how can I get C + 30 days using sheets query and C is text(not date) with YYYY-MM-DD,HH:MM:SS format?

@coupleracademy

Ай бұрын

Hey there! Great question! 😊 You can add 30 days to a date in text format using a combination of QUERY and DATE functions. Here's how you can do it: 1. Convert the text to a date: =DATEVALUE(LEFT(C1, 10)) + 30 This converts the text date in C1 to a date and adds 30 days. 2. Use this in a QUERY: =QUERY(A:D, "SELECT A, B, C, DATEVALUE(LEFT(C, 10)) + 30 WHERE ...", 1) Replace A:D with your range and adjust the SELECT statement as needed. Let me know if you need more help!

@RTRT-jr8jv

Ай бұрын

@@coupleracademy Thank you for trying to help but DATEVALUE(LEFT(C, 10)) function is not allowed in QUERY