All Questions

Filter by
Sorted by
Tagged with
0
votes
0answers
28 views

How to make Pivot Table repeat row labels *without* expanding all columns?

I am making a spreadsheet for doing some analytics and determining win, lose, or draw percentages. The pivot table is all fine, except that Column A is a date column, and if I choose to not have all ...
0
votes
0answers
4 views

How to remove the blue bar that appears in the address bar results in chrome? [migrated]

How do I remove the blue bar appearing in my chrome address bar next to the results it gives me as I type a url? You can see the blue bar in the image above where it appears next to chrome's result ...
0
votes
1answer
23 views

Also apply filter to matching messages - Gmail filters

"Also apply filter to matching messages" Checking this box in a Gmail filter ONLY works when creating or editing a filter. The box apparently gets un-checked subsequently. I have a need for ...
0
votes
0answers
18 views

How to formulate a vector in Wolfram Alpha?

Wolfram Alpha is the best calculator. However, today I needed to calculate the vectors, specifically this formula But I don't know how to write it correctly. How should I formulate vectors in Wolfram ...
0
votes
2answers
29 views

Generate sequential numbers in first column based on value in other column

I'm having a problem implementing a spreadsheet with several sheets that use data registered continuously on the first. I found a solution with this script on the forum but I don't know how to edit, I'...
0
votes
0answers
11 views

How to apply basic formatting to a Wordpress article as a raw text file?

I'm writing for a blog that uses Wordpress and I'm curious if there's any way for me to apply basic formatting to different parts of the article, e.g., headings, links, lists, etc. if I don't have the ...
0
votes
1answer
13 views

Counting a cell if another cell has certain strings

Have a cell which will either have W, L or BB in it. I want to add the cell in O6 if the N6 cell contains any of the strings mentioned below what is the code for this? below is what I currently have ...
0
votes
0answers
9 views

How to search for hyphen- oder underscore-separated words in Google Drive?

For better compatibility, my filenames don't contain spaces. However Google Drive does not seem to support partial searching expect when separated by spaces. For example, if my filename is "...
0
votes
0answers
8 views

Why is Brave not exporting my bookmarks properly [migrated]

I use Brave for a browser. I like to export my bookmarks on the bookmarks page to save them but usually Brave only exports part of my bookmarks. And it seems like every time I export it, a random part ...
0
votes
0answers
30 views

Sequential update of Google Sheets

On page 1 of my spreadsheet I have a bunch of Google Finance functions to retrieve historical data of various scrips. On page 2 I have some calculations running based on the historical data and on ...
-2
votes
1answer
33 views

How to resize the image?

What is wrong with this signature of mine? For this set of instructions? I have resized the image well enough but where did I go wrong? How am I supposed to edit the image? https://ibpsonline.ibps.in/...
0
votes
0answers
6 views

How to get keyboard shortcuts working again in Google Docs?

I am on a Mac Big Sur. For whatever reason, keyboard shortcuts in Google Docs have stopped overwriting the built-in Safari keyboard shortcuts. For example, Cmd-I no longer makes things italic in the ...
0
votes
1answer
15 views

Combine rows that have different values into one row for the specific value in column A

I have a big list of items that unfortunately split the items into 2 rows but with differing values in different columns. Is there a way to combine them into 1 single row like this? Any help much ...
0
votes
0answers
4 views

Linking Info Between Two Different Docs [duplicate]

I build book bibles for a living using Google Docs. For a series, I have a series main info page, and then a separate document for each book. Is there any way to link a name in the second document to ...
-1
votes
0answers
17 views

How can I search for emails containing embedded images in the Microsoft Outlook web interface?

Searching for body:png only returns emails containing embedded PNG images. Is there way to search for any image format?
0
votes
0answers
11 views

Pull Steam name and Numerical ID with IMPORTXML in Google Sheets [duplicate]

I'm trying to create a an IMPORTXML forumla that will pull a Steam name and numerical ID from a profile and paste it into the cell in the following format: SteamName (123456789) I tried this formula ...
0
votes
0answers
7 views

Is there a way to be notified when a LinkedIn member switches jobs?

This means even if the member hides job updates. I've tried some "track web changes" webapps but their previews just show the "welcome to LinkedIn, please sign up" screen. Is there ...
0
votes
0answers
6 views

Can I make a circle's perimeter have line jumps in draw.io?

I know how to make a connector have line jumps, so it has a gap when another line crosses over it, but is there a way to make a circle have a gap when a line crosses over it? If there isn't a way to ...
0
votes
1answer
20 views

Simplify Google Sheets Sum Formula?

This might be a super easy fix. I'm just getting started with formulas and I want to simplify my document so it can run a little faster. I have a big sum formula: IF(D2<>"X - Done";C2;...
0
votes
1answer
27 views

How to get a link to an exact time in a Microsoft Stream video?

Both on Youtube1 and Google Drive2, it is possible to create a link which starts the video at some specific time. On Microsoft Stream, when I write some timestamps into the description, after clicking ...
0
votes
0answers
8 views

Viewing shares on business post

I made a post on my business page and it says that I have 46 shares. But when I click to view, there's only 14. Why is that? My post was a giveaway and sharing is an entry so I needed to be able to ...
0
votes
0answers
12 views

How to fill a column with a default value of 0? [closed]

I got a google spreadsheet with 6 fields. How can one make a column have a default value of 0 that an user can change if he wishes to?
0
votes
2answers
18 views

Remove black background from copied and paste text in google docs

I have a weird black background from a text I copied and paste. Do you know how I can remove it? I already tried something in Page setup ...
0
votes
1answer
14 views

Display data on its respective sheet/tab if it matches value

need your help once again to solve a mystery If "CleintList" sheets mention a service then display it on another sheet. Example: if it says, "WebDev" then add it to the WebDev ...
0
votes
0answers
6 views

Email recovery problems [duplicate]

I tried to use my email after a long time. I forgot the password. I also used the Forgot Password option. The mobile number is verified but the e-mail sends the verification again to the same e-mail ...
0
votes
0answers
8 views

=IMPORTXML() XPath_Query Question [duplicate]

I'm wondering what I should use for my "XPath_Query" in google sheets if the highlighted text is the text I want it to pull up: I tried " =IMPORTXML(C124,"//h1[@class='...
0
votes
0answers
4 views

How do I specify price for a private event?

I am trying to organize private events at a cost, originating from my Facebook profile (not a page). Automatically it says the event is free, though. Can I change that to specify a specific amount in ...
0
votes
0answers
19 views

What happens to Facebook business page if Facebook deletes the personal page that created it?

I have a business page that I created. Recently, Facebook has threatened to close the personal account that I created it with. If Facebook deletes my personal account, does it also delete my business ...
0
votes
0answers
19 views

Google Sheets Checkbox Query/Pivot/Other Question

For my pizza hobby I keep track of the pizzas I like to make and the ingredients in them. I have a good sheet with the following data. I would like to make a view of the same data where I can see ...
0
votes
1answer
77 views
+100

Can I implement this moving average with missing periods using ARRAYFORMULA?

I have these columns: A person_id B date C cupcakes_eaten D date-35 (35 days prior) There can be multiple rows with the same person_id and same date. There can be days with zero rows for a ...
1
vote
1answer
32 views

Can I “unlink” a specific Google Drive's directory from Google Docs?

I use Google Drive for many purposes, and one of them is backuping some stuff. Unfortunately (for me) - I see all the documents in the 'backup' directory also in the Google Docs, which I don't really ...
-1
votes
2answers
28 views

ReferenceError: MONTH is not defined

Using the following Google Sheets script: var currentMonth = MONTH(TODAY); I receive the error ReferenceError: MONTH is not defined. Why is MONTH not defined?
0
votes
0answers
19 views

Is the author of Microsoft Outlook calendar invitations notified when I invite others from the resulting Google Calendar invite

In my Gmail account, when I receive a Outlook calendar invite (in the form of an .ics file attachment which is using iCalendar format), and then forward that even to a different Gmail account, I do ...
0
votes
0answers
103 views

Login to my account

PayPal make my day, can't pay my invoices, can't access to my account, can't contact support because need anyway verify it by phone or text and my old number is inactive. Is not even possible to post ...
0
votes
0answers
3 views

Google Text-to-speech - How to read text input from file? [migrated]

I am using the Google TextToSpeech API in Node.js to generate speech from text. I was able to get an output file with the same name as the text that is generated for the speech. However, I need to ...
0
votes
0answers
6 views

How do I regain access to an old GMail account, with forwarding to another account I have access to, is enabled? [duplicate]

I have an old GMail account A I have lost the password to. A forwards all messages to B (B is also GMail). I have forgot the answer to the security question but I am still logging in from the same ...
1
vote
1answer
30 views

Does google sheets do “lazy” calculation?

E.g. In gnu make, the program keeps a dependency tree for what files depend on what other files. So if one file is changed make doesn't have to 'make world'. In Sheets does it keep a topological ...
0
votes
0answers
11 views

Distributing a google table between multiple sheets [duplicate]

I have to keep track of number of hours spent on tasks per person. In order to make everything more readable, instead of putting it all in a single sheet, I'm dividing tasks into categories and ...
0
votes
0answers
4 views

Replacement for mailto: Extension? [migrated]

I've been using the 'mailto' google chrome extension for years. It allows -- or rather allowed -- me to right click on a page and choose a menu option to email the URL. Fine and dandy. Today I went ...
0
votes
1answer
16 views

How do I chart timeseries data organized by one of the columns?

Here's what seems to be a simple common thing in excel/sheets that I can't seem to be able to google in the right way. three columns: timestamp, email, things_done. I want a chart with time as the X ...
0
votes
0answers
9 views

(How) can I search Google Photos by meta data like shutter speed?

Does Google Photos allow users to search by meta data? For example, I'm looking to browse photos with an exposure time of at least 4 seconds. I've tried searching for 'long exposures' in the search ...
0
votes
0answers
9 views

How to turn a TYPE of Facebook notification back on again?

I’ve used Facebook function to turn off certain types of notifications under the bell icon... Basically you chose type of notification you don't want to see, click on the three dots and click "...
-1
votes
1answer
27 views

how to select and automate “copy by value” to persist data in Google Sheet

I would like to use Google Sheets as a form to query for data, select and store the data I'm interested in. Below what I'd like to try. Please let me know if feasible, and if so, could you tell how to?...
1
vote
3answers
35 views

'contains' and 'starts with' cannot match text with a character after a hyphen

Google Sheets queries cannot match text using contains or starts with when there the text to match contains a hyphen, and the hyphen is not the last character in the text to match. Am I doing ...
3
votes
2answers
119 views

cannot drag query across multiple rows (overwrites data)

Is it possible to click and drag queries? I describe my problem below and also have a reference sheet. cells A1:B5 Category Withdrawal CatA 4 CatB 2 CatA 6 CatB 11 cells C1:C3 Check For CatA ...
0
votes
0answers
17 views

How to delete a built-in Google Docs keyboard shortcut

I'm a French minor, so I often use the ENG INTL keyboard to write in French. Unfortunately, the shortcut to write « » is the same as the Google Docs shortcut to change the zoom to "fit": ...
1
vote
1answer
15 views

can't upload any 100MB+ file to my digitalocean droplet - I get timeouts

I have a droplet I set a password for and set filezilla to access it. Filezilla can view the directories on it and create a directory on it. I have some video files on my local machine, they are e.g. ...
0
votes
0answers
18 views

How to stop google showing localised results and search world wide instead? [duplicate]

I searched for 'coins' in images and at the top of the results on screen 16 of the 22 results are exclusively Australian coins and the 6 remaining results were other coins. Is this a great coincidence ...
0
votes
0answers
13 views

Double lines division representation [duplicate]

How to make a fraction to display a numerator on top of the denominator in Google Sheet?
0
votes
0answers
7 views

sizing photos with new sites

I migrated to new sites and all the image sizes have been altered, I had them to fill the width of the page. I now have to go through hundreds of photos to alter them. I see the only way is moving ...

15 30 50 per page