All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
18 views

Summing groups, Aggregate costs by items in groups

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 ...
0
votes
0answers
3 views

Repeating GA1.1 prefix on Google Analytics ClientID

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....
0
votes
0answers
5 views

Better understanding 2FA [closed]

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 ...
-1
votes
0answers
8 views

How to analyse the results of Google search by the frequency of domains/websites appearing in my exact search?

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 ...
0
votes
0answers
7 views

Need a date field in Cognito Forms that displays just the Month & Year in the date-picker

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 ...
0
votes
1answer
8 views

How to sort Google (or any other search engine) search results by shortest titles first?

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
0
votes
0answers
19 views

Generate a number based on two drop down list selections

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 ...
0
votes
1answer
32 views

Google sheet pop up info

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 ...
0
votes
1answer
21 views

Google Sheets Formula Not Working in Excel

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 ...
0
votes
0answers
13 views

How do I change textStyle of labels in radar chart?

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 ...
0
votes
0answers
6 views

My Bootstrap CDN is not working [closed]

My Bootstrap CDN is not working showing this error please help me
0
votes
1answer
14 views

Type error: cannot read property getid of null in google script

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' ...
0
votes
0answers
7 views

I am facing this error while integrating Twitter login in my Laravel project [closed]

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

URL Image Filtering: URL Suffixes and Wikimedia

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 ...
0
votes
1answer
18 views

Avoid keeping adding numbers in headings in Google Docs

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 ...
-1
votes
1answer
20 views

Can I block someone from sending emails from their Gmail account to mine?

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 ...
0
votes
0answers
9 views

IMPORTHTML not fetching the correct webpage [duplicate]

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?"...
0
votes
0answers
9 views

Import data from google sheet two into google sheet one if SHEET1CELLA1 equals a specific value

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 ...
1
vote
0answers
12 views

Custom 404 page not working (Blogger)

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;"><...
0
votes
1answer
24 views

#REF!, How to Grab the first response of form and ignore the duplicate in google sheets

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) ...
0
votes
1answer
28 views

How to use importxml to pull just one of several lists

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 ...
0
votes
0answers
17 views

Problem with my Facebook account!

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 ...
0
votes
1answer
30 views

Can I change a Google account from "business" to "personal?"

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 ...
0
votes
0answers
4 views

Java Selenium ChromiumDriver - detect properties from browser [migrated]

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

COUNTIF function not showing in google sheets?

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?
0
votes
0answers
9 views

How to use hyperlinks in google spreadsheets to email threads for multiple users at the same time?

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 ...
0
votes
0answers
7 views

How do I upload "an old SD card full of photos" to Google Photos (from Windows laptop)?

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. ...
0
votes
1answer
16 views

How to sum cells that are in hexadecimal format

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 ...
1
vote
1answer
13 views

Activating cell after button click (remove focus from the button)

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 ...
0
votes
0answers
6 views

How to download a Google Drive data files/documents without Google Photos included in the Takeout?

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 ...
0
votes
0answers
9 views

Google Sheet search to return data from additional rows below

=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 ...
0
votes
0answers
5 views

Managing duplicates photos & videos in both Google Drive & Google Photos?

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 ...
0
votes
0answers
11 views

Google Sheets Merging two sheets together with common rows and uncommon rows

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 ...
0
votes
1answer
18 views

Auto add a row based off a check box

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 ...
0
votes
2answers
38 views

Google Sheet Formula Error

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"....
0
votes
1answer
12 views

Google sheets formula to calculate hours elapsed between two datetime stamps & exclude weekends

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 ...
0
votes
1answer
16 views

Possibility of Saving Hidden Value in a Repeat Group as A Case Property in CommCare?

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 ...
0
votes
0answers
13 views

Problem with Query Count distinct col with a where clause

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, ...
0
votes
0answers
10 views

specific recurring date, if x then x

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, ...
1
vote
0answers
9 views

Can I change my Facebook Page settings so that sharing Page posts will automatically include the original post (i.e., original text)?

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, ...
0
votes
0answers
6 views

How can I move individual Youtube videos to my other youtube channel?

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 ...
0
votes
0answers
4 views

How to batch deliver Gmail inbox and labels/categories?

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 ...
0
votes
1answer
20 views

Combining & sorting two datasets with no overlapping data (google spreadsheet)

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--...
0
votes
0answers
10 views

Trying to count values with multiple criteria

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 ...
0
votes
0answers
5 views

Telling Google which image on a page to use in its preview in Google Docs

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 ...
0
votes
0answers
9 views

How can I see the locations having more than 1000 reviews on Google Maps, in a certain area?

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 ...
0
votes
1answer
18 views

Google Spreadsheets: Filter from an already "uniqued" values (or vice versa)

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 ...
0
votes
0answers
10 views

Google Workspace automatically forward mail and change from-address

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'...
0
votes
0answers
15 views

Do I have to create a new user in Google Workspace to create a shared inbox?

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 ...
0
votes
0answers
5 views

Removing a Chrome Extension not showing up in list [migrated]

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/...

15 30 50 per page