All Questions

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

Filter the data of two different column

I'm trying to filter down the data of two different columns. I have exported the Time Tracking Report from JIRA which consists of the following columns: Issue Type Key Status Priority Summary ...
1
vote
2answers
2k views

How to add subtitles to any YouTube video?

I would like to know if there is a way to add subtitles to any YouTube video.
1
vote
1answer
42 views

I can only receive call on the GV number at present

I have a google voice number linked to my iPhone number. How do activate the GV number to make calls? I can only receive call on the GV number at present
0
votes
1answer
156 views

How do I calculate weighted rates in Google Sheets?

I would like to calculate the cost on $D "Rent" with a weighted cost when the respective cell in $B="PB". The calculation would be based on the formula 7x+1.3x=1252 where 7 is dependent on COUNTIF(A2:...
0
votes
1answer
20 views

How can I use TODAY() as part of a formula checking against a list of dates in Google Sheets?

I'm trying to use the TODAY() formula to check against a long column of date cells, and mark them as 'LIVE' if the given date is less than (or equal to) today. Crucially though, if the date cell is ...
28
votes
6answers
99k views

How to insert the current date into a Google Spreadsheet?

I've got a spreadsheet in Google Drive and one column is meant for the date the entry is made. Is there a button to do this? I'm aware of the functions =NOW() and =TODAY() but their description says "...
0
votes
1answer
26 views

Convert table into list

I need to convert a table into a list so it can be used as a database Into this:
0
votes
2answers
337 views

Keep posts on Friends' timelines from appearing on mine

When I post on friends Facebook Timeline, whatever I put there appears on my own as well, how can I stop this. I'm not putting it on mine, only theirs.
0
votes
1answer
726 views

How to create a 3 column chart in Google Sheets with one numerical column and two text columns with customization?

Consider this data: +---------+----------+-----------+--+--+ | Food | Quantity | Type | | | +---------+----------+-----------+--+--+ | Apple | 3 | Fruit | | | +---------+-----...
-1
votes
0answers
7 views

Console based webAPI access

Here's an over simplification of our integration system - we need to fetch orders, put them in some files to be picked up by another system, then acknowledge those orders (its like notifying - yes we'...
0
votes
1answer
16 views

How to make time series chart, where all rows are labelled and dates are not unique?

Say I have some data like so | Month | Count | Type | | | |-------|-------|------|--- |--- | | 1 | 2 | A | | | | 1 | 3 | B | | | | 2 | 1 | A | | ...
2
votes
2answers
1k views

How to print Facebook friends list

I need to print out my friends list on Facebook. However their instructions just bring me to a blank page. Something is wrong on my account since this happens on whatever PC, laptop I use. Is there a ...
0
votes
1answer
875 views

Google Script to set the current month once a day only in a cell

Currently, I'm using (Month(NOW()) to set the current month number in cell $D$1 of a spreadsheet. I know Month and Now are volatile functions and they're making the over sheet update way too slowly, ...
3
votes
3answers
51 views

Since the changes on 21st Feb 2018, is it possible to add a link to my website from my YouTube video?

I'd like to add an overlay of some kind to my videos, so people can directly click through to my website if they wish. But all the tutorials I've found on how to do this, with annotations, cards, etc ...
0
votes
1answer
20 views

How to see replies to your comments on YouTube?

When I accidentally opened the notification window two times the replies there disappeared.
0
votes
2answers
1k views

Google Sheets automatically converts a string to a number

I am using Sheets as a front end to view tons of different IDs and credentials associated with my authenticated access to a 3rd party API. When calling this function, I get this result: ...
1
vote
0answers
235 views

If I Accidentally Unsubscribe and Resubscribe From A YouTube Channel, Upon Checking When I Subscribed Will They See The New Date?

The title says it all. I'm wondering if resubscribing changes the subscription date. I was on Nintendo Switch YouTube, and accidentally clicked the “unsubscribe” icon. I resubbed within seconds and ...
1
vote
1answer
52 views

Why watch time different in Youtube Analytics and Monetization page?

Recently my Youtube channel crossed 4k hour watch time in the last 365 days. I have 1301 subscribers and 4.4k hour watch time. Please see the attached image. So, as per Youtube rules I can apply for ...
0
votes
2answers
525 views

inputBox in onEdit does not work for users

I have a strange problem... Simple function like: function onEdit() { var ss = SpreadsheetApp.getActiveSpreadsheet() var sheet = ss.getActiveSheet() var ui = SpreadsheetApp.getUi() var response = ...
1
vote
1answer
170 views

Dynamic generation of sheet name from cell content (cell contents from importrange)

I have a list of names of the members of my group. Each member has a separate sheet that contains information on that member. When a new person joins the group, I input the name to the master list and ...
0
votes
1answer
561 views

How can I make a hyperlink from Google Spreadsheet cell to an Excel file?

How can I make a hyperlink from Google Spreadsheet cell to an Excel file? For example the hyperlink is in Google Spreadsheet and opens the Excel file. The Excel file is on the hard disk not on Google ...
1
vote
1answer
3k views

Does LinkedIn sometimes require sign-in to view profiles?

For a few weeks, LinkedIn has been requiring me to sign in before I'm allowed to view profiles, including my own. I know it's not simply an invitation to join LinkedIn because: There is no "skip" ...
3
votes
1answer
49 views

Hold position relative to content in a rapidly changing Google Docs document with many editors

I'm trying to edit a big Google Doc with many editors all typing at once. When people above me type and add or remove text, the document reflows, and the part I am trying to edit moves from page to ...
-1
votes
1answer
35 views

How do I get Google Sheets to automatically subtract a value from one cell by entering the value in another?

I have a budgeting spreadsheet on Google Sheets which I’d like to be able to do two things (the first, I think, is easier than the second and the first is the priority for me): I write a value in, ...
0
votes
2answers
32 views

“IF” Functionality Inquiry

So I am trying to figure out how to whenever it's a "Y" and "INCOMING", then it will equal a dollar amount. So as if a + b = 1 then equals $35 =COUNTIFS(F3:F100,"Y",B3:B100, "INCOMING") I did it a ...
33
votes
8answers
118k views

Add subtitles to a video of another user on YouTube

I would like to offer a translation to another user's video on YouTube. The original video is in Spanish and I would like to write a Hebrew translation that would be relevant to very few people. The ...
0
votes
0answers
14 views

Extracting PDF data directly into Google Sheets

It blows my mind that I haven't seen anyone else with this issue yet, but here is the situation: I'm looking for the best method to convert a PDF into a Google Sheet (or how to scrape the data). I've ...
0
votes
1answer
20 views

How to replace data from one column into a placeholder in another

Some thing that does this: I'm thinking in Google Sheets have column A be let's say City, and column B be let's say address, then I want to paste something into column C like: "Are you looking ...
-1
votes
0answers
8 views

I need help formatting data that is not delimited. The information needs to be in 2 cell and then flow down the sheet

I have a data field that is words and their abbreviations in alphabetic order. I started with the "A" and added the commas. I need better efficiency than that. Also with the commas, the ...
-1
votes
2answers
161 views

Persistent notification in Google Hangouts Chat app on iPhone

The Google chat app has an extra persistent notification - all messages and room are "read" - It is always 1 more than Hangouts. - It does not go away with reinstalls - It does not display in web ...
0
votes
1answer
26 views

How To Edit Title Caption?

I am unable to edit a title caption on photos I posted in Google Shared Photos. Is there a way to edit the title caption?
0
votes
1answer
34 views

Find transactions from new paypal addresses

Demo sheet - https://docs.google.com/spreadsheets/d/1H78_Y7H_KOe1HKEKAdqcucUYV1NjsQBstUERzvURJcs/edit?usp=sharing This is used in an attempt to reconcile paypal payments from different domains - quite ...
0
votes
1answer
4k views

Google Sheets Conditional Formatting Isn't Working

I am making a spreadsheet in Google Sheets and my conditional formatting works in some cells and not in others. I have gone so far as to delete all of the formattings for the entire workbook and ...
1
vote
1answer
44 views

ImportHTML Altering Data Format/URL Fetch Issue

4/17 6PM Update *** I am now trying to use the URL Fetch App. I've been playing with this for hours, but can't seem to figure out the issue. I am just trying to get the info from this site as plain ...
1
vote
2answers
6k views

How to know if Google Sheets IMPORTDATA, IMPORTFEED, IMPORTHTML or IMPORTXML functions are able to get data from a resource hosted on a website?

Google Sheets has several import functions IMPORTDATA IMPORTFEED IMPORTHTML IMPORTXML Sometimes the above functions returns errors like #N/A Imported content is empty and would like to be sure that ...
1
vote
1answer
28 views

Google Sheets: filtering and matching a list treating NON-unique values

I have a list (column A) of non-unique text values. Items from that list are put into column B (via dropdown data validation). Any items from column A that are missing in column B are shown in column ...
0
votes
0answers
25 views

IMPORTHTML waiting on data

I am fairly new with query language, but I have been looking around the internet to find a solution to this problem without any luck. I'm trying to import data from leaderboards on specific tracks in ...
0
votes
1answer
96 views

Google sheets join arrays

What I'm trying to do is to join few arrays of dates. For start, I have start date and amount of months I want to generate. Which I did by using =ARRAYFORMULA(DATE(YEAR(A2), MONTH(A2) + SEQUENCE(C2, ...
0
votes
1answer
17 views

My files on my Google Drive disappeared but are still searchable and use up my quota?

Background: My Google account X was getting full so I tried to delete some files from the Google Drive part of the account. A and B are folders, X and Y are accounts. I had a folder A on my Google ...
1
vote
2answers
2k views

If I like a friend's old post, would my 'Like' appear to our friend's (mutual) news feed?

If I like a friend's really old post (2011 - something he posted to me - it actually appeared to me on my "ON THIS DAY" section) would my 'Like' appear on our mutual friend's news feed? I don't want ...
1
vote
1answer
29 views

Google Sheets: aggregate and extrapolate irregular data over time

I have a list in which I now-and-then (no fixed interval) enter the available budget. Most of all I want to extrapolate this to a future trend of the coming 10 years. (no rocket science, more of an ...
0
votes
1answer
16 views

Door are not showed properly after upload visio document

I uploaded visio with proper placement of door using microsoft, uploaded the same file in draw.io but didnt get proper result. Can you please suggest what I am doing wring? Please find attachments ...
1
vote
2answers
1k views

Conditional Formatting based on other column

I have a timesheet log with columns DATE | HOURS | DESCRIPTION OF WORK | PROJECT An employee may enter several rows for the same date to log the different amount of time with respect to the ...
0
votes
1answer
2k views

How can I easily link to a bunch of files in my Google Drive from a Google Sheet (in the same account/drive)?

I have a bunch of PDF files in a single folder (say "myPDFs") in my Google Drive. I have a Google Sheet stored in the same Google Drive. One column of this Sheet has the filenames of the PDF files. (...
4
votes
1answer
2k views

Programmatically create an internal hyperlink

I need to programmatically create a large number of links in a Google Sheets that point to a specific range in another sheet of the same document. I tried to use named ranges for that but for the ...
3
votes
1answer
7k views

Show all posts and comments in a Facebook group that I am a member of, not an admin

I am a member of a group and I would like to see all the posts and comments from the beginning of the group (approx 8 months ago). Is there a way that I can do this without spending hours simply ...
14
votes
5answers
28k views

If I buy a movie on YouTube, will it also be in my Google Play library?

If I buy a movie on YouTube, will I also own it on the Google Play Store? For instance, if I were to buy Tomorrowland on YouTube, would I have it in my Google Play library?
1
vote
1answer
145 views

Search for a range of numbers in the title on Google News

I'm trying to find a range of numbers inside of titles in Google News. I tried something like intitle:4..25 but it only found results for which the exact string 425 appeared. Any ideas?
0
votes
0answers
3 views

Can't add pending members

Please help! I need to sort this out asap. I created a Google Group and invited people. Half were instantly made members and the other half are listed as "pending members." I do not know why ...
0
votes
2answers
27 views

Google Photos sucking up all storage

I'm using Google Photos to back up my photo and video library. It's set up to store data as "high quality - unlimited storage". However, it's complaining about exceeding my storage quota in ...

15 30 50 per page
1
3 4
5
6 7
607