All Questions

I have a sheet with a grouping by Feature / Subfeature / Task. Here is an example: How can I aggregate the cost from individual tasks to subfeatures (eg. rows 147-150 of Sign-In subfeature group) and ...

I've noticed an increased amount of strange ClientID numbers in Google Analytics' User Explorer with a prefix GA1.1. In normal cases the ClientID is presented without the prefix. Examples: GA1.1.GA1.1....

Why does 2FA fail unless geo-location is enabled system wide ? Solutions offered ( https://debiankalilinuxtips.substack.com/p/automatic-datetime-sync ) for date/time sync do not resolve 2fa requiring ...

For example, if I am searching for 'Mario Party', how can I analyse the search results by the websites that have the words 'Mario Party' in them. I want to see the websites that have the most webpages ...

Is there a way to format a Date field in Cognito Forms to just display 'Month & Year' and not the calendar day in the Date-picker? I am asking the user to mention the Expected Project Completion ...

Or how to make the titles of the search results only contain the words I have searched for and no other words in the titles apart for that

I'm trying to create a pricing calculator for my handmade business. I've gotten really far and have all my products separated out on different sheets based on material type, then have those sheets ...

I use google sheets for woodcrafter members to log time to use our woodworking shop. The shop has a keycode entry and members are only to enter if they have booked time. All members were given access ...

I have this formula pasted below that works in Google Sheets, but not in Excel. I've looked up possible solutions, but just cannot find what may be the problem with it. The return I get is just the ...

I'm making a radar chart using Google Apps Script and I don't know how to change the font size of the "labels" (see the picture). So far I've tried hAxis, ticks, legend and none of them ...

My Bootstrap CDN is not working showing this error please help me

When I run this script it show me this error. I can't understand what I do. Its function is to transfer results from html form to Google Sheet. Can anyone solve this problem? var sheetName = 'Sheet1' ...

Received HTTP status code [401] with message "{"errors":[{"code":32,"message":"Could not authenticate you."}]}" when getting temporary credentials.

Wikimedia image suffixes used in url strings with "File:" resolve to neither TLDs/public suffixes, nor hard links to image formats, but to html pages. In other words, WikiMedia images are ...

I am using a modified version taken from this useful answer to get numbers in my Google Docs Header 2: function myFunction() { var pars = DocumentApp.getActiveDocument().getParagraphs(); var ...

I want to block all emails from a Gmail account that keeps bothering me to my Gmail account. I can mark the messages as SPAM, however this does not “block” the messages since Gmail will deliver future ...

I made a spreadsheet, a part of which uses the IMPORTHTML function to get data from this webpage. What I've written is: =IMPORTHTML("https://www.rbi.org.in/scripts/FS_PressRelease.aspx?fn=9?"...

I would like to change the value in a certain cell, and have that import the complete data from another sheet that contains service information on specific unit# so that I can have multiple hidden ...

So I wanted to make a custom 404 page on my Blog. I went in Settings > Errors and redirects > Custom 404 And pasted this Markup: <h1 style="height: 0px; text-align: center;"><...

I have a google form for attendance and I have a formula to automatically calculate the salary from the attendance. Sometimes people fill out the attendance twice with the same status (work/go home) ...

This site has answers to a game called Spelling Bee which is published daily. I want to use importxml to pull the answers (which is a list of words) into Google Sheets, but I am a novice on this ...

My Facebook account has hacked. I changed the password and login to it again. The problem is that my account has been locked, they asked me to upload my ID. I uploaded it and got an email with a link ...

The organization we work with implemented a weird rule that demanded that we change the name of our business. I hadn't setup a google account in a while, so I clicked the business account type during ...

I invoked url: https://antoinevastel.com/bots/ and receive some different results A) from desktop chrome: detailChrome {"properties":"unknown","connect":206,"...

I hope you are doing fine. I am trying to count a specific text from a column but when I type the count if it does not show up. Can someone help me with this, please?

I'm running some data in Google spreadsheets and need to link a lot of different email threads to that spreadsheet. I need different users to have an access thru these hyperlinks directly to the email ...

Context I have an old SD card full of old photos. (I've actually copied the card to a folder on my laptop) Goal Upload all 800 pictures to Google Photos in "one shot". (i.e. All 800 at once. ...

First of all, read 32, 1023 with the 0x32 and 0x1023 to identify that it is a hexadecimal number. When we only have numbers the sum is done with decimals and it seems to work. The problem is that in ...

I have a sheet with one button (a shape) which is associated with an Apps Script function. When I click the button it inserts a row and activates a cell in that row. Then if I try typing, nothing ...

I recently attempted to download all Google Drive data from Takeout. When making my selections such as from "Multiple formats", "Advanced settings", and "All Drive data ...

=transpose(FILTER({Log!S:S,Log!Y:Y,Log!Z:Z!AB:AB},Search(B37,Log!S:S))) returns adjacent cells in all rows it finds. How can I also get cells from the same columns n rows below from where search ...

The relatively recent divorce between Drive & Photos still has me a bit confused. Though to be honest, I was never really sure of this question: Before the changes, when I shared a Drive folder ...

I have two Google sheets each with 4000 columns and 8 rows. I would like to merge these two sheets together using 6 of the common columns and writing over 2 of the uncommon rows. Into a new sheet. Is ...

I'm a new user to Sheets! I'm reaching out for help on a problem that I have with trying to create row. I've read a ton of blogs, and watched more Youtube videos than I care to admit without finding a ...

Hoping to get a little help with a formula I am making I have used it in other columns to calculate an outcome, but for some reason when I go to decimals under 0 it give me a #N/A "No Match"....

What is the best formula to calculate the hh:mm:ss lapsed between end datetime and start datetime and also exclude weekends? I know I can simply subtract end and start datetime ( End Datetime - Start ...

Is it possible to save a hidden value as a case property, especially if the hidden value is a repeated value? I have attached a screenshot of what the derivation of the field that I want to save as a ...

https://docs.google.com/spreadsheets/d/e/2PACX-1vSac8-YOPZUih1gKI3uTHbfJpIew3QwQ6ccM0Od7lF-E4eLyb-y2adRsrJ9JpyDulkbsMbhIt-qwXaJ/pubhtml Link to an example. On the total tab, I have: =QUERY(data!1:963, ...

hi i was wondering on google calendar or really if there is another calendar that does this if it was possible with like a code or something that you could make a recurring date. Like for example, ...

I run a Facebook Page, and when people have been sharing our posts that include external links, the original text disappears. I know that there is a workaround for people who are sharing the content, ...

I started making investment videos on my personal youtube channel. I'm now starting a new investment channel. I found how to move an entire channel. I just want to move a few videos. I prefer not to ...

Is there a way for Gmail (or an extension) to delivery new messages in bulk at pre-specified times or upon request. It would be like 'send/receive' with the receive on pause. Ideally, I would like ...

How to combine and sort two sets of data not always overlapping? see example below. Thx edit: Example in google sheet https://docs.google.com/spreadsheets/d/15Vp_G_GX5fqD-OBXBv--...

I have a file that contains a planner with dates in the lines and the roles of my team members in the columns. I need to be able to count how many people are working per day and per role. I need to ...

If you add a URL to a Google Doc and then hover over it a preview of the page is displayed including an image from the page displayed as a thumbnail. Is there an html tag I can use to suggest to ...

I am wondering how can I see the popular locations (e.g. having more than 1000 reviews), on a certain area on Google Maps. This would be helpful when traveling quickly through a city, to find ...

I would like to know if and how I can filter a list of values which was already created by the unique() function? Example: Suppose I have a column of values with duplications. Abc 433 Gal 653 Dov 123 ...

We are using Google Workspace (Business Standard tier) in our company. I would like to provide a mail address which is forwarded to another mail address with its sender address changed. For example: I'...

I have set up a Google Workspace with 3 users having a unique email. I also want an email "info@domain.com" that goes into a separate inbox that we all can collaborate on. Will I have to add ...

I installed a Chrome extension today but it's not showing up in my toolbar, under the puzzle piece icon, or on chrome://extensions/. I searched for any instances of this extension under ~/Library/...