New answers tagged

-1

How much memory (RAM) do you have? How full is the hard drive? Check both of those first. There could be a simple solution. Adding more RAM is the easiest. https://www.memoryx.com/hp.html has the least expensive RAM. Your model is about 3/4 or more towards the bottom. They sell more RAM than anybody and ship or mail to you. You go through their lists to find ...


0

I ended up finding the answer here: https://www.cloudbakers.com/blog/export-google-calendar-entries-to-a-google-spreadsheet Here is a generalized version of the script that ended up working: var mycal = "myemail@email.com"; var cal = CalendarApp.getCalendarById(mycal); var today = new Date(); var endDate = new Date(today.getTime() + (7 * 24 ...


0

Dates are basically numbers and Google identifies blanks as 0 when comparing to numbers, thus you have to add check for blanks. =ARRAYFORMULA(IF(A:A="","NO",IF(A:A<=TODAY(),"LIVE","NO")))


1

You can use HTML tag to verify your site provided you can add some meta contents to your site. They would give you some html like <meta ....> Click on try a URL prefix property. Then click on the URL prefix tab. Here, you have to enter your URL with https and press Continue. You will be given the options to add meta tags for your site verification.


1

SPLIT will work: =SPLIT(A2,"?",0,1) Here, SPLIT views the split character (i.e, "?") as the same whether there is 1, or whether there are 500 of them in a row. Of course, this can be applied to an entire column as well: =ArrayFormula(IF(A2:A="","",SPLIT(A2:A,"?",0,1))) Your post shows "?" as the ...


0

Each line of your data file is 12 characters long, and consists of four elements: two digits, twp question marks, five digits and three question marks. The question marks are separators. SPLIT is not a good option in this case because the separators are not consistent. Try MID instead. =value(mid(A1,1,2)) - will return the first two characters =value(mid(A1,...


0

You have an aggregate — SUM(Col17) — which means you need to GROUP BY some column (e.g., add "GROUP BY Col1" to the QUERY before LABEL). If you don't tell the QUERY how to organize (i.e., GROUP) the aggregate function, it will throw an error.


1

Hunter, it's always tough to write formulas without access to an actual spreadsheet and data. Even with what you shared here, there are a lot of unknowns. So you'll always get the fastest and most accurate solutions if you share a link to a sample spreadsheet, being sure to set permission to "Anyone with the link can edit." That said, based on the ...


Top 50 recent answers are included