All Questions

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

Can I retrieve the names of sheets in a public document?

I am currently using the function IMPORTRANGE in a Google spreadsheet to pull information from a public document using the URL. I have to supply a range_string in the format "Sheet Name!A1:D21" to ...
0
votes
0answers
2 views

I want to send Google Form response to an Email address entered on the form

When a user completes the form to attend a conference. I ask for another email address so their supervisor knows they have signed up and for what date. How can I use the field on the form as the ...
0
votes
2answers
298 views

I cannot comment on YouTube after I watch a video. I'm using my Kindle and it says “…oops something went wrong”

I am unable to comment on videos I watch. It says "..oops something went wrong". I watch on my Kindle. What can I do?
1
vote
1answer
65 views

How to create comma and hyphen separated list of sequential numbers in Sheets?

How do I create a list of numbers, where consequential numbers are reduced to being separated by a hyphen? e.g. I have a column with numbers like 1 2 3 5 6 7 8 10 12 I want this to be reduced to 1-3,...
0
votes
1answer
28 views

How can I view how many texts I received from a given phone number on Google voice? [closed]

I don't want to manually count the texts, and I don't have archives of the emails Google Voice sends me. How can I view how many texts I received from a given phone number on Google voice? Does Google ...
0
votes
1answer
21 views

How can gaps be quantified within a combined set of variable arrays?

I'm using Google Sheets to build a crop planning tool for farmers (kinda like a gantt chart). I need help quantifying the number of days within a given timeframe that no crops are planted in a bed. In ...
1
vote
1answer
863 views

Google Sheets Conditional Formatting only applying formatting to certain cells

I am currently working on making a spreadsheet that will figure out which class I should be in based on times. That all works and outputs if I should be in the class to a TRUE/FALSE cell. My ...
1
vote
1answer
39 views

Comment section on my blog disappears

When there are no comments in a post, you can still see the comment section, for example: https://duonghoimanga.blogspot.com/2018/11/takane-no-ran-san-chap-14.html However, as soon as someone ...
1
vote
1answer
44 views

Is the other person notified if I follow then unfollow a person on github?

I accidentally followed someone on Github. Then I unfollowed them within 2 minutes, will the person receive any notification?
0
votes
2answers
59 views

Suming values in a column if value in cell next to it matches another cell

I'm trying to create a sheet to maintain a small inventory of servers. I created a segment where each type of component will be listed at the top. Below it is a series of copy-pasted chunks which ...
0
votes
0answers
2 views

Zoom Webinars: How to extend end date for recurring series

My organization has several webinars that recur weekly. In order to avoid offering sessions too far in advance, the "End Date" for the recurring webinars is set month-to-month. However, we ...
0
votes
0answers
8 views

Set Postfix myorigin to the domain that sent the email for multiple domains (Google Workspace SMTP Relay)

I have a Google Workspace account that has multiple sites running on one user. I have aliases setup for gmail. I've setup a Google Workspace SMTP Relay to send emails from my linux server for systems ...
6
votes
2answers
366 views

How to find large files and specific file types?

I've tried different options in the search bar and searched Google far and wide but can't find help. My unlimited Amazon Drive account has been discontinued so I'm trying to prune it of all the large ...
3
votes
2answers
8k views

Import JSON to Google Sheet using Google Apps Script

I am using Apps Script in Google Sheets to import JSON from Google Analytics. I have previously used the ImportJSON function to easily get the JSON from an open API just using =ImportJSON(url) within ...
1
vote
1answer
177 views

Google Sheets row minimized to almost nothing when no data is present but needs to auto expand to be fully seen ONLY when data is present

I've got a Google Sheet I'm creating for settlement purposes and I have 8 variables that only get used sometimes. Each variable has its own line devoted to it. For example, this load has a scale ...
0
votes
0answers
4 views

SSL Certificate Validation after Upgrading Website [migrated]

I've recently acquired a SSL certificate from a certificate authority called GlobalSign nv-sa. The certificate is already in use. What I am curious to know is what happens if I change major parts of ...
41
votes
4answers
30k views

Why does Slack limit the number of contacts in my sidebar's direct messages section?

Slack seems to limit the number of contacts shown in my sidebar's direct messages section to 10 or 11 contacts. If I start a direct message with somebody new, another conversation is removed from the ...
0
votes
0answers
5 views

Changing question format, but keeping content in Google Forms

Q: I started drafting a survey in Google Forms, but then decided that the content might be best represented in a different format (drop down, multiple choice, etc.). However, when I try to select a ...
1
vote
1answer
521 views

Chart labels disappear (stays outside the graph area) Google sheets

Really count on your help here, as it seems like I tried everything already. Take a look at the graph: the last value label disappears (the location is right on the inner border of the graph, so the ...
0
votes
0answers
11 views

How to get the max number in a column up to a cell google sheets and excel

This code would be in B8: =if(C8="","",1+max(C5:C7)) Then in B9 i would have this: =if(C9="","",1+max(C5:C8)) and Eventually ending with: =if(C8="&...
0
votes
1answer
12 views

Using query function with (matches) empty cell

=query(A1:S10,"select C,D,E,F,H,K,P,R,S WHERE Q='USA' AND R matches 'Florida|NY|''' I would like to add (or empty cell) to the 'Florida|NY' That is to say I would like to select rows with the Q= ...
0
votes
0answers
2 views

Setting User Name in Google Groups strictly through an elist (not suite) Does Not Work Any More and It Needs To?

Up to six month ago putting a person's name then and directly adding them to a group for an elist worked. Now It Doesn't. And I really need to know their names - not just a reiteration of their email ...
1
vote
2answers
13 views

How can I display Google Sheets dates as Month-Day with the underlying data in UTC format (YYYY-MM-DD)?

I want to display a date in Google sheets as Month-Day (e.g. Jan-10) with the underlying data as: 2021-01-10 However in order to show Jan-10, Google Sheets defaults the underlying data to 01/10/2021 ...
0
votes
0answers
17 views
+50

How to find a list of my YouTube comments that have been deleted?

I imagine that, sometimes, a YouTube video poster will delete a comment I post. Is there ay way of know if or when that has happened? When I try to search for an answer, everything is about me finding ...
1
vote
1answer
41 views

Conditionally format a column if it contains all the values in a set

Each of the columns in my Google Sheet represent a farm. Each farm is a list of animals. I want to highlight the entire column if the farm has a duck, a horse, and a cow. So the column may look like ...
0
votes
5answers
8k views

How to remove the open to work frame on LinkedIn without changing other things?

I am actively looking for a job and used open to work feature on LinkedIn (all LinkedIn members can see that I am open to work). Recently LinkedIn comes out with a new feature "open to work frame&...
0
votes
0answers
5 views

Disable Slackbot spam

I see this spam message from Slackbot often: Good news! Slack can now do more with Google Drive files, like help you share files and manage who can see them. It is "permission spam" when ...
1
vote
1answer
3k views

YouTube won't take channel art.

I upload the channel art, adjust the crop, save it, and then it changes from the upload prompt to a white box. If you refresh the page the upload prompt is back. Tried on Chrome.
0
votes
0answers
5 views

Turn on notifications Facebook group pending posts

I used to get notifications from pending posts of the group - in which I am a moderator - in the notification screen (the globe icon). Unfortunately, I haven't received them since a couple of days. ...
2
votes
2answers
1k views

Can't filter a column to see all cells containing `@` in Google Sheets

I'm trying to filter a column to show cells that contain @ (as in an email address) but when I put @ in the filter box it comes up with a blank. Any ideas? An example spreadsheet here. Here is also ...
31
votes
3answers
27k views

How do you move a row in a Google Docs Document table?

[The question is somewhat obsolete; the new behavior does something reasonable on a paste when you've copied an entire row. As far as I can tell, there's still no way to move a row directly. The ...
0
votes
0answers
11 views

How do I generate a filtered list based upon multiple checkboxes?

I am trying to create a random magic item generator for my D&D table. Here's what I have so far. In this instance, Uncommon and Armor are selected. I want to make it so that only the two uncommon ...
0
votes
1answer
69 views

How to use arrayformula to find and get data from only a certain, dynamic set of columns?

I have a table where my headers are dynamically generated from another source and can show up with any header values, in any order. In the example below I've got the header values: AA - BB - CC - ...
0
votes
0answers
6 views

Transfer business page to a new personal account

I am leaving my company and I need to remove my personal account from the company's business page. However we are restricted from advertising and it says I cannot change any admin access or add new ...
0
votes
0answers
14 views

Google Sheets - how do I randomize a selection and ensure it does not repeat

I have been struggling with this for the longest time, and potentially may be going about this the long way but... What I am trying to do is randomly select a row and have it populate in B2 of the ...
0
votes
0answers
5 views

Is there a way to auto-update footer text in a Google doc based on Version History's most recent date, or the date of most recent change? [duplicate]

I have "Last Updated 1/20/21" in the footer of my Google doc and with numerous people working on it - we'd like to have this date change automatically based on version history. Can this be ...
0
votes
0answers
15 views

I'm very much still ALIVE and well.but Facebook memorialize profile

I'm very much still ALIVE and well don't know how Facebook can memorialize an account without proof of death.its been quite upsetting!
0
votes
0answers
21 views

Can my Facebook friends see if I'm tagging myself in my old photos?

I recently discovered that if I am tagged in a photo of myself, either automatically by Facebook using its machine learning algorithm or by manually tagging myself, it shows up on the more prominent ...
0
votes
1answer
17 views

Differentiating automatically and manually cc-ed YouTube videos

As suggested by the title, suppose I’m given all the video links under a YouTube channel. Is there anyway that I can tell if each video has close captions automatically generated by YouTube or ...
0
votes
0answers
2 views

Spotify Can't play the current song

Once in a while my spotify on Mac laptop will stop working, showing up this blue banner saying "Can't play the current song". I reinstalled spotify but it didn't work. I also found this ...
1
vote
1answer
12 views

Using query function with ' where Col1 or Col2 is not null'?

=query({TOIM;IMTO},"SELECT * where Col1 is not null ORDER by Col11",0) Where TOIM,IMTO are named ranges. I want to rewrite the formula with two criteria (OR). In other words like this =...
0
votes
0answers
2 views

drawio - how to set non-overlapping connections by default?

Is there a setting that tells the connector not to overlap with other artifacts, e.g. shapes or other connectors? see picture below. also in this case each shape has 5 connection points on each side, ...
0
votes
1answer
8 views

How do I unlink two columns in Google Sheets in regards to conditional formatting?

This has to do with right-clicking at the top of a column in Google Sheets to add another column to the left or right. When I do this, the conditional formatting from the original column carries over ...
0
votes
1answer
14 views

Preventing Amazon from automatically unsubscribing me from my questions

Whenever I ask a question on an Amazon product on Amazon, after one or two days Amazon automatically unsubscribes me from my question, and I get an email about it. Is there any way to prevent Amazon ...
0
votes
1answer
28 views

Why isn't “info” icon in Google Photos showing up for me?

I created a link to share a photo in Google Photos. When I view this photo under my own account I see an "info" button (an "i" with a circle around it) that I can click to see things like when the ...
0
votes
0answers
4 views

Facebook share button missing from company page

I manage a company page on Facebook (https://facebook.com/emotionathletes). I am able to share it to my friends from my computer browser ("Partilhar" is "Share" in Portuguese): A ...
0
votes
0answers
4 views
0
votes
0answers
76 views

How to fetch only the required data set for a query in ImportJSON?

I am trying to fetch the latest price of BTC/INR from a JSON HTTP URL of a exchange. https://api.wazirx.com/api/v2/trades?market=btcinr I am using the following formula in Google Sheet to Fetch the ...
0
votes
2answers
39 views

How to forward multiple emails at the same time in Gmail?

I looked at this thread and it does not look simple enough.
0
votes
1answer
25 views

Arrayformula function keep getting error different sizes

I'm trying to sum rows with specific criteria with the following formula =ArrayFormula(sum(countifs(disposition,"Consultation" ,Primary,{"","OB_Gyn","Surgical"}...

15 30 50 per page
1
2 3 4 5
619