All Questions

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

How do I remove a “null” column or legend in Google Data Studio?

I have a simple Google Sheet for my source for Google Data Studio charts. Legends in pie charts and columns in bar charts show a "null" that I can't explain. My columns display correctly but there's ...
0
votes
1answer
59 views

Alternate to Nested IF statements

Goal here is to have the sheets search a row, then once it finds the first instance of >=0, return the cell value that contains the month+concatenate the value in the cell next to it (or any other ...
0
votes
1answer
3k views

Why does Chrome log in Gmail automatically?

When opening Chrome browser, and whenever loading a page, it will show my Gmail address at the upper right corner of the web page, does that mean the Gmail is logged in automatically?
0
votes
2answers
87 views

Viewing & editing data in Google Sheets using a form

Is there any way to view and edit data in Google Sheets in a form, like MS Access or OpenOffice Base can do that? It would be perfect if we could cycle through each record, which would be the ...
0
votes
2answers
1k views

Running a script from inside a sheet cell

I have a simple gsheet I want to run a script inside so it can be run from Android mobile. Buttons and menus do not work on Android mobile. C3 says choose your sort. D3 has a data validation list ...
0
votes
1answer
807 views

Facebook login notification approval?

Apparently my Facebook login notification emails me if someone has logged-in to my account, without any approval link/code in the email they send me. Is that really the way it's supposed to work? ...
0
votes
1answer
695 views

“other” response not collected in Google Forms [duplicate]

I have created a survey using Google Forms many of which are multiple choice with an "other" option at the end and a small box for users to enter their own response. In the results spreadsheet it ...
0
votes
2answers
288 views

Cannot Find Function 'getRange' in Google Script

I'm working on setting up a series of scripts for a google sheet where I want to be able to auto sort based off of when something gets entered into the third column, sorting first by the first column (...
0
votes
0answers
56 views

Getting the real destination link from google search [duplicate]

Steps to reproduce: Search for "wavetek4.pdf" via Google search: wavetek4.pdf. Look in the entry. Right mouse click on the link and it goes to Google. Not to the real site. Click on Share button to ...
0
votes
0answers
730 views

Choose the option to reset your security questions

I expect to see: but see: and then: Not knowing the phone number, how do I proceed? The clear, explicit, and wrong directions specify: Reset your security questions Go to iforgot.apple.com. ...
0
votes
2answers
218 views

How can 2 people use the same Gmail account and filter incoming e-mails for each user considering Labels are applied per message?

So this one is a serious head-scratcher that is proving much more difficult to resolve than at first glance. I have a Client that runs a small business. They are a husband and wife team and use ...
0
votes
1answer
928 views

Sum numbers in a range of cells that contain a mixture of text and numbers

I've got a range of cells in Google Sheets that contain a mixture of text and numbers, e.g. Yes 46, Yes 35, No 23, Yes 21, Yes 14, etc. Can anyone help me with a formula that would add up the numbers ...
0
votes
1answer
849 views

Restrict the valid values in one cell, based on the value in another cells

I am trying to prevent a date being entered into a cell if the date precedes the date in another cell.
0
votes
0answers
187 views

Restore access to a Google group after being incorrectly labelled a spammer

I started a thread in a Google Group, posting via the web-based editor. The third or fourth post into the thread my posts stopped showing up. The thread shows only that there are some deleted messages....
0
votes
1answer
375 views

Highlight Rows with Unique Values As Compared to Rows with Same ID# on a Different Sheet

I have two sheets: The first is the Master Sheet of responses to a survey. The second will be an Update Sheet auto-generated from the new responses. New responses can be either entirely new rows ...
0
votes
1answer
2k views

How to zip two columns together in a Google Sheets [duplicate]

For example columns are setup as: A | B ----- 1 | a 2 | b 3 | c 4 | d 5 | e I want to be able to make column C be like this: C --- 1 2 3 4 5 a b c d e via formula. The two columns will ...
0
votes
2answers
76 views

ArrayFormula for conditional consequential sum-up?

I have a table which looks like this: And formula in cell B3: =IF(A3>5, B2, B2+1) and on every next row a corresponding variation of this formula. I would like to know how to create ArrayFormula ...
0
votes
1answer
217 views

Inverse of Google Sheets GetSpreadsheetNameById

This post Display sheet name in Google Spreadsheets shows how to get the name of a Google sheet, given its URL. I have the opposite problem. I know the Spreadsheet name, but I want the URL to use in ...
0
votes
1answer
61 views

Complicated formula nesting issue in Google Spreadsheets pt2

I'm currently trying to develop a complicated formula for a work project and I've hit a roadblock. This spreadsheet tracks people’s physical performance in five specific areas during a physical ...
0
votes
0answers
66 views

How to get rid of new Gmail design? [duplicate]

So I've tried new Gmail design. I couldn't image it is that ugly and unpleasant to use. How to roll back to previous normal Gmail design? New Gmail design:
0
votes
1answer
796 views

Facebook alternative interface [closed]

Has anyone attempted to produce an alternative interface for Facebook using their API? If so, which site is the most complete?
0
votes
1answer
266 views

Sum the value of the cells above going up until blank cell

I want to sum the cells above of the current one until an empty cell is found. For instance, in the image below, in the summary row, I want to sum the revenue from the orange cell (the red one) going ...
0
votes
1answer
1k views

How can I calculate compound interest with different interest rates?

Assume that I have the following different interest rates for different periods. I would like to calculate a compound interest rate based on these rates for lets say 200 periods. How can I do it ...
0
votes
1answer
6k views

How do I delete all contacts in Google apps permanently?

When you have synced your contacts on your Android phone with Google contacts and decide to withdraw them from Google, how can you permanently delete them? I went to Gmail->Contacts and there I could ...
0
votes
1answer
1k views

How to remove the name of a recipient

GMail has recently rolled out a new method of composing a message: the composition appears as a popup stable at the bottom of the screen, and one can look at other mail for reference, say, while ...
0
votes
0answers
1k views

Yahoo Mail: Search knows old emails exist but they can't be shown

A family member has a problem with Yahoo Mail that is new to me. All her emails older than a couple of weeks ago no longer appear in her inbox-- sorting newest to oldest does not scroll past a certain ...
0
votes
1answer
1k views

Dynamically Building Array Of Sheet Names From A Range Of Cells

I have a (fully working) formula which looks across all the other sheets referred to in an array, and sums up all the costs in one of the columns in those sheets. It works just fine - my question is ...
0
votes
1answer
4k views

Way to automatically download or print attachments or URLs from emails with specific labels

More and more companies are sending electronic invoices. Some do so by attachment, others by embedding an URL to an on-line location. For URLs, some require login or cookie, some don't. I'm ...
0
votes
1answer
34 views

Partial cell formatting with CONCATENATE in Google Sheets

Is there a way to format partially using CONCATENATE in Google Sheets? For example, =CONCATENATE("*", Sheet1!A1, Sheet1!B1), and I want to make the * bolded or blue in color or something else. I ...
0
votes
1answer
3k views

How to make tags, comments, notecounts, date, permalink, and etc. visible?

Can someone please help me? I'm having difficulties trying to make my tags, comments, notecounts, date, and permalink visible on my Tumblr layout. I have attempted to do it but it was all just ...
0
votes
0answers
28 views

Trouble copying cards [duplicate]

How do I copy a card? I keep reading that I have to tap the side bar on the back of the card. I'm assuming the side bar is those little grey lines... But they don't respond to tapping. I know I am ...
0
votes
1answer
64 views

Using CHOOSE with ArrayFormula has different results from Excel

Function CHOOSE within an ArrayFormula seems to yield different results in Google Sheets, compared to Excel. Note how only the first column is shown. Should I report it as a bug, or am I missing ...
0
votes
2answers
2k views

How do I list all users that documents are shared with in Google Docs/Drive?

We have over a thousand documents that I need to verify whether they are being shared and if so with whom. There doesn't appear to be a way to list all users granted access whether internal or ...
0
votes
2answers
317 views

Filtering an instance by a case property in my CommCare app

I am working on the CommCare mLabour app, which tracks women from the onset of labour through delivery via digital partograph. For the contractions graph, I need to write an instance which filters to ...
0
votes
2answers
52 views

Export PDF link sheet ID auto change

I have the link for export as PDF a specific range on a sheet =HYPERLINK("*****export?exportFormat=pdf&format=pdf&gid=962914045&range=A1:H68&pagenumbers=false&gridlines=false&...
0
votes
0answers
340 views

How do I set or change my avatar in Trello? [duplicate]

Possible Duplicate: Can I use the profile picture from my Google account as my Trello avatar? I can't find where the option is to set or change my avatar. Is this even possible?
0
votes
1answer
1k views

Google Sheets How to Hide or Show Specific Columns using Custom Menu [duplicate]

I've figured out how to create a custom menu, but I'd like to be able to hide or show certain columns (not necessarily ranges), based on what menu item is selected. Not sure on the next steps / can't ...
0
votes
1answer
47 views

Migrate Google Chats from One Google Account to Another

I have two Google accounts - an old one that I used for a while as a kid, and a new one I opened when I became a working professional and needed a professional-looking personal email address. It's ...
0
votes
1answer
2k views

How to move a row into another sheet?

In Google Sheets, I need to hide rows if column H says, "Completed" My preference would be to cut and copy the row to a new sheet if column F reads "Completed", but sounds more difficult. If you ...
0
votes
2answers
1k views

Calculating time worked per day

How do I add time like 8:20am-12:00pm and then after lunch break 12:30pm-5:02pm to end of day to get hours worked per day? I was using =(B2-A2*24)+(D2-A2*24) but that doesn't work
0
votes
1answer
31 views

Sum of rows until a condition changes

I have a Google Sheet with the following format: A B C D 10-12-18 17.36 Start 10-12-18 17.49 Stop 13 10-12-18 17.49 Start 10-12-18 17.51 Stop 2 ...
0
votes
3answers
66 views

Picking the Total from the Next Week

I have the next year mapped out (one line for each day) and have the week subtotal at the end of each week (which is a Friday). I am wanting the Next weeks subtotal to show in another cell for that ...
0
votes
1answer
443 views

How to escape the Google Adsense login loop

I am trying to get Google Adsense for my blog. I complete the form and click "Save and Continue" and it goes back to the homepage. I click "sign in" and it asks for my email and... surprise surprise......
0
votes
1answer
5k views

Can one still get a free Google Apps Standard account? [closed]

I know there was a workaround that was working a few months ago to get a free Google Apps account for one user, however, when I tried the workaround this morning it didn't seem to be working. Does ...
0
votes
1answer
644 views

How to trigger a script when a new text value is added to specific column?

I've built a sheet that generates messages for clients based on certain input data. The message appears in a cell in column B when all the required data has been entered. When a new text value is ...
0
votes
6answers
6k views

How to copy a shared folder into my own Google Drive?

It seems like the Make a Copy option only works for individual files (not for folders). When somebody shares a folder with me on Google Drive, how can I make a copy of that folder in my own Google ...
0
votes
1answer
2k views

Finding Facebook profile ID from an image URL

I was forwarded an anonymous concern about a photo or group site. I want to find the user id as the photo appears to have been removed. The link is https://www.facebook.com/photo.php?fbid=...
0
votes
1answer
1k views

Is it still possible to paste an mp3 link into a Facebook status? [duplicate]

Possible Duplicate: How to upload an mp3 to Facebook? I work for a public media radio station. We are currently working out a plan for extending our brand through the use of social media. One of ...
0
votes
2answers
3k views

How do you create an installable trigger for a Google Apps Script?

I've searched all over Google's documentation on this topic and I haven't been able to find a tutorial or article that explains how to do this. I completely understand how to create simple triggers in ...
0
votes
2answers
27k views

What do I do if I forgot my Gmail password? [duplicate]

Do I need to contact Google if I've forgotten my Gmail password?

15 30 50 per page