Category "google-sheets-formula"

How do I use a query to get a date from an array formula?

On sheets, I'm using this formula to sum hours to a specific month from a drop-down menu. =QUERY('Form responses 1'!H2:L, "Select L, Sum(K) WHERE L is not NUL

Google sheets: Count Specific Characters in a string of words

I have on Google sheets this data (It is the same principle in excel). I want to count the numbers of dose in each strings. I use this formula and it return me

how to combine many google sheets in one sheet by using query

I created two online sheets and tried to collect them in another one sheet by query but there a missing data although it's exists in the original sheets (data s

How to use REGEXEXTRACT for day and time?

I am using a third-party app that allows me to log in my day, time and location at the push of a button, on a google sheet. (source: imggmi.com) While the app c