All Questions

1
vote
2answers
1k views

How can I set the increment value for Google Spreadsheets to auto-increment?

I have a series of cells referencing other cells: | Row | a | b | col B shows | |-------------------------------| | 1 | 1 | =a2 | 2 | | 2 | 2 | =a4 | 4 | | 3 | ...
0
votes
1answer
7 views

Chrome and Hangouts both use CTRL+D for something different

I'm using CTRL+D to mute my hangouts, but that does bookmarking in Chrome. Any way to resolve this schism?
0
votes
1answer
12 views

Get translation using Google Sheets and IMPORTXML

I want to scrap the phonetic guide for a translation in Google Translator using Google Sheets. For instance, if you enter the page: https://translate.google.com/#view=home&op=translate&sl=...
0
votes
1answer
29 views

Google Sheets onEdit - Run Two Scripts

I'm trying to run two scripts in one sheet - Only the last one runs though - I'm sure I'm missing something small but any ideas? function onEdit(e) { moveRowsFromSheetToSheet_(e); ...
4
votes
1answer
53 views

Add Bitbucket button to webpage

It's easy to add GitHub buttons to webpages as a way to link to your profile. Is there an analogous button for Bitbucket accounts?
0
votes
1answer
31 views

How do you get current date to be added to a cell when a check box is checked in another cell

I want to get the current date added into a cell when a tick box is checked in another cell. I currently have another formula in the date cell which changes its colour when the tick box is checked, ...
54
votes
11answers
19k views

How can I sort emails in Gmail by size?

Google has started to warn me that I am almost out of space in my Gmail account. How can I sort my messages by size to identify any expendable large emails in my account?
0
votes
1answer
8 views

Split function doesn't get the result that I expect

A1 value is 485065/1, 2, 3 and I expect 485065 and 1, 2, 3 but it comes out 485065 and 1, 2, 2003. =split(a1,"/",false) Please help me why it does.
0
votes
0answers
5 views

ga:dcmLastEventAttributionType (CM Attribution Type (CM Model)) with Last Interaction Conversions

we have a Google Sheet that is using the Google Analytics Add-on. we can pull all kinds of 'normal' metrics fine but we need to pull our Last Interaction Conversions from GA into this Spreadsheet. ...
0
votes
1answer
1k views

Is there a way to remove the “related pages” block from the Facebook pages?

I manage the Facebook page of a company, and at the right appears a "related pages" block added by Facebook which shows a link to the Facebook's page of the competition company. Is there a way to ...
0
votes
0answers
11 views

Cognito Forms API to get All Forms in embed website

Is there any API that can expose all the forms that are created on Cognito Forms?
1
vote
2answers
27 views

Importrange when copied to other cells automatically change range

I am using importrange to pull data from my responses page to my spreadsheet. I have completed the first sheet but I now need to go into the sheet to follow on where sheet one has run out of space. ...
0
votes
1answer
10 views

Twitter log-in issue no phone to receive sms

I no longer have access to the phone number I used for 2 step verification. I do not have a backup code either.
0
votes
1answer
19 views

How can I get an incremented date range using a table field in Cognito Forms?

I am creating a timesheet template for my organisation. The user should be able to add 10 entries (one for each weekday in the fortnight worked), plus the hours worked. Using a table, I have created ...
1
vote
1answer
100k views

What does “hide comment” mean? What happens if I choose that?

My friend tagged me in a random post and I wanted to remove the tag but unfortunately could not. I selected "hide comment" option but what exactly does that mean? Does that mean that the comment is ...
0
votes
1answer
60 views

Do people who have rejected your friend requests still show up in “People you may know” on Facebook?

I don't remember whether I sent a particular person on Facebook a friend request. The option to add them as a friend is open which either means I did and they rejected it, or I didn't. I don't want to ...
-1
votes
0answers
12 views

Facebook changing owners does it take away credit card info associated?

My boss set up all kinds of pages for our different programs at our nonprofit, through her personal page, meaning she logged into her personal page then created new pages. When she put in a credit ...
0
votes
1answer
10 views

Trying to fetch data from this website with ImportXML function in google sheet

I am trying to fetch store name and cashback percentage from this website using google sheet's importxml function. Put following commands with no success. Please help =importxml("https://www....
0
votes
1answer
12 views

1 plot with several lines with a common X axis but unique X and Y values… is this possible?

I am trying to create a graph which shows several smooth lines that are defined by an X and Y value. the problem is that they have to share the X-axis. Is there a way to efficiently add the other ...
-1
votes
0answers
8 views

Problem with resetting Uber password [on hold]

I made my account on Uber Lite, which only needs your phone number and not email ID, and at some point I added a password too. I forgot that password and tried to reset it, but without a linked email ...
1
vote
0answers
5 views

Posting to Google Groups via E-mail - Error if attachments exceed 25MB in total

My understanding with the May 2019 changes the Google Groups posting size was increasing from 8MB to 25MB. When posting by email I am receiving an 8MB size limit error. Is there a parameter I need ...
0
votes
1answer
19 views

Any way to receive LinkedIn emails at an alternative address?

LinkedIn requires you to set a "primary" email address, which will be visible to the others. However, they also send tons of emails to this address. With some services such as Github, you're able to ...
0
votes
0answers
4 views

Google Sheets Grouping with filter

I am trying to achieve the following: a sheet where a client is in one row and below it his/her items appear, they form a group these groups stay together for the actions cut/paste/filter/sort, as ...
-1
votes
1answer
8 views

Script to Duplicate Template Tab Multiple Times and Rename Tabs from Cell Range?

Basically, I have a list of 200 people's names in the range 'Names'!A1:A200. I have another tab named Template. I need a script to duplicate Template 200 times and rename each of the tabs to the name ...
1
vote
2answers
228 views

In Slack, is there a way to filter out search results from a specific channel?

I know you can do in:#channel to only get results from a channel, but is there a way to filter out results from a channel? A lot of our channels are spammed with automated messages and it adds noise ...
0
votes
0answers
12 views

Is there a way to filter out partial matches from search results on YouTube?

When searching for “JoJo's Bizarre Adventure,” I frequently just search the keyword “jojo,” but my first sight is often greeted by a musical artist by the same name. Instead, I'd prefer that all my ...
1
vote
1answer
9 views

Issue with finding the averages of multiple rows at once

I am currently tasked with hundreds of rows of data for a project. I need to take the average of each row, but there are way too many rows for me to do by each individual row. Is there any way to take ...
6
votes
4answers
17k views

How can I make some data Autosort in a spreadsheet on edit?

I am working with a simple spreadsheet that has name/lastnames in it. I need for the spreadsheet to automatically sort the entry alphabetically by the last name (column B). I have used the following ...
0
votes
1answer
28 views

OnEdit won't apply to all tabs in Google Sheets

I am running a script that automatically organizes priority in a to-do list. It works great on the current tab, but when moved to a sheet within the worksheet the same OnEdit function will not run. ...
0
votes
1answer
8 views

How to get an access_token for Riot / Matrix?

In the Matrix instant messaging protocol, when using the reference implementation of the Matrix server (called synapse), there is an admin API with functions like resetting a password for a user etc.. ...
-1
votes
1answer
1k views

Delete multiple sheet tabs in Google Sheets

In a Google Sheets spreadsheet (Excel terminology = workbook) is it possible to delete multiple tabs (Excel terminology = worksheet) in one go without having to right click each one and delete it.
-1
votes
0answers
24 views

G-mail on iphone doesn't populate address [on hold]

I recently updated the G-mail app on my iPhone. The TO: section won't auto populate the way the previous version did.
1
vote
1answer
2k views

How to create a (recurring) Gmail Calendar Out of Office Event?

I’m going through the Google Calendar API, and I can’t find a way to mark an event as "Out of Office". I work from home every Thursday — and by default in the Gmail Calendar one cannot make OOO ...
0
votes
1answer
3k views

Make cell “flash” onOpen rather than onEdit

I need a Google sheets script which will make the background color of a cell flash. Currently I have a script which works fine, but onEdit. It would be far better in this case if the script could work ...
0
votes
1answer
65 views

Is a shared Google Photos album publicly searchable?

I'd like to share a Google Photos album only with one person and allow them to view and edit the album, but I do NOT want the album or any photos to come up in search results. I saw that the only way ...
-1
votes
2answers
38 views

Change a cell to a colour when a tick box is checked in another cell

I have a cell with a checkbox. I want another cell which contains a date to go green when the tick box is checked. I presume this is done in conditional formatting but I am struggling with it.
2
votes
1answer
867 views

Request for Edit Access using View Access

I have been provided with a link only to View a particular folder. Is it possible for me to request for Edit Access? If so, how can you do that?
-2
votes
0answers
60 views

My restore old google account [on hold]

I already. Have a my old google account. But i. Restore my password. So i can. Revtert my old google account. And all. My ifom
-1
votes
0answers
14 views

Changed Trello password on PC but app still logs in on old [on hold]

I changed the Trello password on my PC When I go the Trello App on my phone - which still has the old password - somehow it is still logging in using that! I thought it might be a cache so I added a ...
9
votes
3answers
5k views

How to customize the toolbar in Google Docs?

Is it still impossible to customize the toolbar with extra buttons? Specifically, I'd like to add the strikethrough one (especially with how horrendous the keystroke for it is), but a general solution ...
6
votes
6answers
23k views

How do I save a photo from an eBay listing?

I wish to reuse a past eBay listing but as it is over 90 days old, eBay will not let me edit it, therefore I want to save the photos from the listings so that I can upload them to a new listing. But ...
10
votes
4answers
7k views

URL for “I'm Feeling Lucky” within specific site

I'm looking for an URL that goes directly to the first Google hit from a certain domain as in "I'm Feeling Lucky" but limited to a certain domain. I'm using this formula, but it typically doesn't ...
0
votes
2answers
7 views

Using IF functions with formatting in Google Sheets

I'm working on a Google Sheet and want to reformat all instances where the number in a cell is "2" and the color of the cell is pink. Is it possible to use information about cell formatting (here, e.g....
8
votes
3answers
10k views

Split-screen display of multiple Gmail inboxes in one account

I just merged my Gmail accounts and am now receiving all the emails in the same inbox while only having to use one account. That's very practical to me right there. Is it possible to split or show ...
1
vote
1answer
9 views

What does the query parameter “sub_confirmation=1” do on a YouTube link?

I recently came across a link to a YouTube video with ?sub_confirmation=1 appended to the link. What does this do?
2
votes
1answer
17 views

IF Cell = True, then retrieve (separate) Cell Value

Cells: T2 = Price to Pay U2 = (Tick box) V2 = =if(U2=True, "Paid", "To Pay") W2 = empty What I want to do is be able to tick U2 and have W2 contain the value of T2. V2 works, so it does not ...
1
vote
1answer
34 views

How to generate all combinations of letters in a word?

Using Google Sheets, how would I show all possible ways to type a word, for example: word Word WOrd WORd WORD wOrd woRd worD without any length word? The given word would go on Row A and the ...
31
votes
2answers
56k views

FILTER(condition OR condition) syntax?

I am using FILTER() to display a value from Sheet 2 where the Name columns match. My problem is where I want: =FILTER(Sheet2!A:F, Sheet2!A:A="Combat Medic" OR Sheet2!A:A="Universal") as OR results ...
1
vote
1answer
26 views

Automatic merging of duplicate cells under common ID

I have data in column A with IDs and a column B with data for those IDs. Right now I have multiple (usually 2-3) rows with the same ID but different data. What formula to use to merge those into one ...
0
votes
2answers
7k views

How to format the time in this Google Apps Script

I want to format a Google Sheet cell when I read it in my script but it comes out 25 minutes later. The cell's time is 20:00:00 but the output is 20:25. I am using this var formattedDate = Utilities....

15 30 50 per page