All Questions

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

Google App Script to Hide & Show Rows Based on Dropdown Selection on Active Sheet

I am trying to create code that will automatically hide or show rows depending on the selection of the dropdown on whatever sheet is currently active. The drop down selection is a list of all the ...
0
votes
0answers
18 views

Converting multiple columns to list

I'm currently using Google Sheets and I'm capturing data with Google Forms. What I'm receiving from Forms, inside the corresponding sheets is an entry with timestamp, clientID, item1, quantity1, ...
0
votes
0answers
8 views

ArrayFormula / SumIf for multiple columns based on dymanic date / Monday through Friday

I have several form responses sheets (that I importrange into a common workbook) that need to display a total every Monday through Friday of the week that updates for current week Monday - Friday. I ...
0
votes
0answers
9 views

ImportRange and Query Function Data is condensing into one cell

I am trying to create a spreadsheet that imports data from one spreadsheet into another and then sorts that data by a key phrase. Here is the formula I am using: =Query(Importrange("URL","ReferenceTab!...
0
votes
0answers
6 views

Google sheets negative amount in one cell positive in another

I am making Google Sheet and I'm trying to put the negative amounts in cell with the font red and the positive amount in another cell with font blue or green.
-1
votes
1answer
5 views

How to set Google Group so anyone on the web can send us an email?

I've been trying to find an option where I can set google group as a public so anyone on the web can send us an email. Apparently, this is what we have as an http://prntscr.com/q9yy0l appreciate all ...
1
vote
1answer
10 views

How to prevent Google Sheets from reformating input from Google Forms?

I need to create Google Form where users can submit different data. Problem is that some of them use comma and others use dots as decimal separator and my Form should handle them both. Problem is, it ...
-1
votes
0answers
9 views

How many Bitcoin Cash miners are there?

I have found answers about Bitcoin: https://www.quora.com/How-many-bitcoin-miners-are-out-there : 150,000, https://www.buybitcoinworldwide.com/how-many-bitcoins-are-there/ : 1,000,000. And about ...
0
votes
0answers
9 views

Invisible URL on an HTML page

On my personal webpage, I want to refer to these addresses: ''http://link.springer-ny.com/link/service/journals/00041/index.htm'' for the Proc. of the AMS and to ''https://www.ams.org/publications/...
1
vote
1answer
15 views

Add Number of days and time on a datetime field

I have the following sheet: | A | B | C 1 | 23/2/2020 12:00 | 5 | 2:00 2 | 12/4/2020 13:00 | 2 | 2:0 And I want to calculate how many days after and how ...
0
votes
0answers
10 views

How to stop the “friendship anniversary” notifications on Facebook?

I regularly receive notifications in Facebook Messenger about the anniversary of my friendship (amiversaire in the French version) with a friend. Messages like you have been friends with [friend] ...
0
votes
0answers
11 views

Android Gmail SENT says me instead of recipient

Every sent message says me (useless since obviously I sent it from my phone). I see no option to show who I sent it to? Gmail on browser on a Windows 10 PC works as expected showing SENT recipient(s).
0
votes
0answers
9 views

Why am I getting notifications about someone I have blocked on Twitter

I get emails from Twitter for notifications, so the other day I notice I got an email about a notification from Twitter about someone I have blocked what they tweeted! Does anyone know why I’m getting ...
0
votes
0answers
7 views

Using pdf.js in google apps script

Problem I'm trying to extract the text out of pdfs, but I can't get pdf.js to work in gas. Background I have been using advanced drive services and OCR to upload pdfs to google drive and convert ...
0
votes
2answers
17 views

Working With Durations In Google Apps Script

I'm trying to write a function in Google Apps Script to manipulate durations calculated in Google Sheets. The cells holding the durations look like: 18:40:00 26:42:01 When I pass a duration into my ...
1
vote
1answer
14 views

Can someone help me with this google sheets group by query?

I have 3 columns. I would like to sum up the total revenue of Revenue by month in Dec-2019 (As you can see there are 2). And also sum up the Net profit by month(As you can see there are 2), last but ...
-1
votes
1answer
12 views

Cache API Response [closed]

Good Morning! I don't know if this is the right forum for this question, if I'm not sorry. I have a problem with a travel site where the front end is built with Backbone.js and has a backend PHP ...
1
vote
1answer
19 views

Find value in 2 different sheets

So, as you can see from the example google sheet below, is there any way to have a formula in which when you try to find the value from both sheets (Example 1, Example 2; if lets say in Example 3, ...
0
votes
1answer
4 views

How do I export my data from YouTube?

Is there any way in 2019-20 to export all of my data (including comments) from YouTube?
0
votes
0answers
13 views

Combining Duplicate Data Within A Table? | Google Sheets

Table Data: This is a dulled down version of the Data Table I am trying to filter - which is a massive list of leads. Basically, I am trying to find a way to combine all rows with similar contact ...
0
votes
0answers
4 views

Is it possible to add a url-linkable anchor to a Google Drawing?

Is it possible to add a url-linkable anchor to a Google Drawing? So I can share a link to a small part, of a large drawing.
0
votes
0answers
5 views

Bookmarking a video in SlidesLive.com

I am surprise how difficult it is to navigate the video streaming site SlidesLive (https://slideslive.com). For instance, is it possible to bookmark a video in SlidesLive.com? The video frame has an "...
0
votes
1answer
11 views

Optimize Google Sheets to process/summarize large amounts of data [duplicate]

I have a Google Sheet where data is uploaded from a Google Form in one page and workers input data directly in another page. The data is combined into one table via scripts. I am trying to create a ...
-1
votes
0answers
5 views

How to convert bily links to reflect a custom domain?

Using API I created 1000 bit.ly links then realized many carriers are starting to block unbranded shortened URLs. I setup my custom domain on my bitly account but don't know how to convert the ...
0
votes
0answers
10 views

How to check if there is any Data Validation error in the whole spreadsheet?

Is there a way to check in a Google Sheets spreadsheet, if there is at least one cell violating a Data Validation rule? If such functionality is not built-into the app, how can I write a Google Apps ...
0
votes
0answers
4 views

Is there a way to stop youtube hiding the “read more” option? Youtube has kept this problem for a long time since it introduced the problem

Is there a way to stop youtube hiding the "read more" option? Youtube has kept this bug for a long time for example clicking the notification bell, and there are two screens, one where it says "...
-1
votes
0answers
9 views

facebook editing on business page

My Facebook personal account is linked to my business account. I am Unable to edit any content on businesss page. The edits are unsavable. Any suggestions
1
vote
2answers
19 views

What happens to files when deleted from a shared folder which has been added to their Google Drive?

In our company we have a shared folder which has a lot of resources in that the whole team accesses. Somehow one of the sub folders was "Removed" and I can not work out how to recover the affected ...
1
vote
0answers
8 views

Adding new rows when using IMPORTRANGE [duplicate]

I have a spreadsheet as follows: A B C D E F 1 steve 12 xxy yellow 12 a1 2 david 32 yyx green 165 b1 3 tom ...
0
votes
0answers
8 views

Is it possible to have two youtube channels on same emailid (account) and have it monetized?

I am starting up a youtube channel and would like to get it monetized. However i want to have two channels based on different themes. Is this possible. Want to know from personal experience if both ...
0
votes
1answer
5 views

In Google, is there an embedded plagiarism checker?

Is there a way to use a plagiarism checker in Google? I am writing a research project and I do not want to have an issue with this.
0
votes
0answers
3 views

AOL Password for a shared computer

I share a computer with others at church. I have a password to open the computer but I would like to be able to password protect my personal AOL Email account? Is that possible?
-1
votes
0answers
12 views

Calculate Wednesday of the current week

Current week is Sunday through Saturday. I need something to calculate the Wednesday of that week. I'm currently working with =B2+7-MOD(B2+3,7) But this is calculating the Wednesday of the week ...
0
votes
0answers
8 views

What happens when importing old emails to Gmail from an external account via POP if some of them had already been forwarded to the Gmail account?

For years I've had all emails sent to my institution-provided address forwarded to my personal Gmail account, but my institution is no longer permitting this. They do allow POP access, though, and ...
0
votes
0answers
6 views

Google Apps Script send attachment on cell value

First of all I am a complete beginner in coding. So I am trying to build a form, that once it is submitted, will send a different gdrive file as excel sheet based on a key word in the form. So far I ...
-1
votes
0answers
6 views

Will youtube delete unlisted video?

Someone told me that starting Dec 11, if your video does not make any money, they will delete your video. Does that include unlisted video? I do not intend to make money off of my video. I intended ...
0
votes
0answers
2 views

My Google Analytics User login number is all over the place and doesnt match up with login log and i dont know why

i need help clarifying the login numbers for my website. i want to track the number of users who logged in to my website. When a user log in, theyre always brought to /customer/info page, so i figured ...
0
votes
0answers
10 views

The Facebook Marketplace display does not fill a browser window?

As shown in the screenshot the Facebook Marketplace is treating my Retina Macbook Pro as if it were a low resolution mobile device. Is there any way to recapture the full screen width? That is ...
0
votes
1answer
15 views

How can I insert a video from Google Photos into an email using Gmail?

Composing an email in Gmail, I can insert photos from Google Photos as attachments or links easily. But videos in my Google Photos account do not show in the list of media... is there a way to share a ...
0
votes
0answers
4 views

Change Web Gmail swipe actions in iPhone/iOS

In Chrome browser in iPhone, when I open gmail website and open an email and then swipe left/right then it navigates to the previous/next email. How do I remove this swipe action in Chrome or in Web ...
2
votes
2answers
31 views

Set calculation precision in Google Sheets

Google Sheets uses some sort of floating point arithmetic in its internal calculation, even if only integer numbers are in the calculation. For example: A1: =128^128 A2: =A1+1 A3: =A2-A1 Then, A3 ...
0
votes
0answers
3 views

Mobile YouTube website (m.youtube.com), edit comment?

I can add a new comment, and I can delete the comment I wrote, but I cannot find a way to edit the comment I wrote. Is the feature really missing or is there any way to edit the comment other than ...
0
votes
2answers
22 views

Google Sheets If else formula

I'm trying to write an if else statement in Google Sheets. I want the value in cell B2 to dictate what the value you will be in cell D2. If the cell B2 is less than 12 than I want D2 = 17, if B2 is ...
0
votes
0answers
4 views

Is it possible to ignore direct messages and only search Slack channels?

In Slack, how can I search only channels and ignore direct messages?
-3
votes
0answers
16 views

I Created nextButton after click on that button the code OTP enter and progressbar sould show but it;s not working [closed]

public class Register extends AppCompatActivity { public static final String TAG= "TAG"; FirebaseAuth fAuth; EditText phoneNumber,codeEnter; Button nextBtn; ProgressBar progressBar;...
0
votes
0answers
17 views

Importing a Google Sheets range based on checkbox value

I want to IMPORTRANGE of all columns B2:C if the respective A column is TRUE (a checked checkbox). How can I do this?
0
votes
1answer
33 views

Count Occurrences of Unknown Values

I'm really new to Google Sheets and formulas in general. I know you can count occurrences of values when you know what you're counting e.g. the times red is written in the column and you can search ...
0
votes
0answers
24 views

Gmail suggests old contacts

Gmail used to put my most used or most recently used addresses at the top of the suggestion box when I type into the "To" field, and now not only does it not put them at the top, but it doesn't even ...
0
votes
0answers
8 views

Change group avatar as maintainer

Is it possible to change a GitLab group avatar without being the owner? I have maintainer-level permissions for a group on GitLab and would like to change the avatar. The owner of the group is a ...
0
votes
0answers
5 views

Importing excel data to a Google map

Using Chrome : I have 30 longitude and latitude points in cols 1 and 2 of a workbook Transfer.xlsx (Row 1 col 1) = location-long (row 2 col 2) = location-lat I pick out an existing map of the ...

15 30 50 per page