All Questions

Filter by
Sorted by
Tagged with
0
votes
1answer
1k 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
2answers
64 views

I want search engine to find sites containing the most the rare proper nouns I search for

I want to find all apps that do a certain thing. People all over the internet make lists containing some of these apps. For example I want to make a list of all Quantified Self apps. I first search ...
0
votes
1answer
74 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
1answer
66 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
3answers
78 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
2answers
1k 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
1answer
363 views

Sync Chrome with personal G Suite account

I changed my gmail to a personal G Suite account. I'm the only user and the main reason was to have my personal domain with the G Suite (+ some of the benefits with storage). However I'm struggling ...
0
votes
1answer
294 views

Split Master Sheet into Multiple sheets

I have a master sheet where the data is like this: Would it be possible to split this into multiple spreadsheets so it can look like: and the sheets are divided into Weeks? Scripts or formulae are ...
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
3answers
126 views

Else statement is executing when TRUE

I am completely new to coding. I am a teacher and trying to design a lesson planner tool using Google Sheets Scripts. The idea is to have a template sheet for the lesson that will copy into a new tab. ...
0
votes
1answer
407 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
3answers
6k views

Google Sheets COUNTIFS if cell contains part of text, exclude blanks

I am unsure of the use of COUNTIFS with two variables while excluding blank cells from being counted in this scenario, wanted to see if there would be a more viable solution. I am relatively new to ...
0
votes
2answers
93 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
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
2k 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
2answers
118 views

Tweeting without annoying others

I have a twitter feed that sends out new YouTube music videos for a specific genre. I want my followers to easily find the artist’s Twitter page. I'm currently sending something similar to: some ...
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
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
4answers
2k views

Why Download button is hidden in TED?

I was able to download videos from TED simply by clicking on download button since couple days ago. But suddenly it has been hidden now! [it was on the right hand] So, How can I bring it back? or ...
0
votes
2answers
1k views

Search e-mail messages in given period of day or in given period of week

Is there any way in Gmail's filtering mechanism to find e-mail messages received or sent: in a given period of a day (each day -- only time component of date matters here), in a given period of week (...
0
votes
1answer
1k views

How to permanently delete Gmail spam?

Can there be a Gmail Gadget App that permanently blocks or deletes spam? Phong mentions the following in his answer to the question How can I auto-delete some spam from Gmail? If cluttering your ...
0
votes
0answers
59 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
2answers
185k views

Change back to Hotmail from Outlook.com [duplicate]

I have been changed from Hotmail to Outlook.com and I am not satisfied with the new webmail system. Is there any way that I can switch back to Hotmail from this new Outlook.com service?
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
251 views

Small Edit on Import Range Script for Mass Edits on Google Spreadsheets

I found a great video on YouTube about editing Google Sheets in bulk, however the script writes over formulas with cell values. I'd like to have formulas be edited from the master sheet rather than ...
0
votes
1answer
972 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
2answers
11k views

How do I modify this Google formula to filter out blank responses from Google Sheets?

I have Google Sheets running the add-on Form Mule to automatically send emails with the responses to a Google Form. Using the following formula, I was able to get a nice HTML table to show up in the ...
0
votes
1answer
973 views

Choose which photos in Google Photos to change from Original to High quality

I want to save some space in my Google storage. For Google Photos, I am using Original quality, which counts against my 15Gb quota. I know I can Recover storage, which changes all photos from ...
0
votes
1answer
134 views

JOINing code-points after CHAR conversion in Google Spreadsheets

I have a spreadsheet with hexadecimal Unicode code-points in one column. Usually it’s just a single number, which I can convert to a character with =CHAR(HEX2DEC(XY123)). In some cases, though, there ...
0
votes
2answers
426 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
1answer
756 views

How can I go back from YouTube TV to 'normal' Youtube

I followed the advice in this answer and entered https://youtube.com/tv in my FireFox browser. A login screen appeared which I could skip and indeed, all videos appeared in a large full screen format. ...
0
votes
1answer
868 views

Google Spreadsheet Query blanks out text cells in the query range

When I perform a query to essentially filter a range of names, and times, any cell that is not a time gets blanked out. Screenshot of example: I'm keeping this post fairly short since the image ...
0
votes
1answer
7k 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
3answers
609 views

IMPORTXML reading decimal separator as thousands separator

When I import this item via IMPORTXML and the spreadsheet locale is US (or other country that uses dot as decimal separator) it works fine: =IMPORTXML("http://bvmf.bmfbovespa.com.br/cias-listadas/...
0
votes
2answers
265 views

Spreadsheet: function to watch row for changes

Is there a spreadsheet function that can watch a row and update a cell with the current date when any cell in that row changes? If not for the entire row then perhaps just watch a single cell?
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
4answers
4k views

How Can I Sort a Data Range in Google Sheets Based on an Data Range?

I have been looking for a way to sort this information. I need to sort these items in this order: BK, BB, BV, BIV, BIII, BII, BR. I was trying to make a Google Script to get it, but I could only ...
0
votes
1answer
105 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
45 views

Increment the numeric value of Col D by 1 if Col E is “True”

I have tried to follow the example below to color E to Red if E = True Figured I would keep changing the script until What I want is to increment the value in Col D by 1 if the Value of Col E is "...
0
votes
1answer
2k views

How do I allow sign-ins from unusual locations in Google?

I work for a company that provides internet to the users through proxy servers located in the USA and Switzerland, which results in all kinds of inconveniences, of which the most annoying is the fact ...
0
votes
0answers
537 views

Split contents of comma separated cell and send to new row(s) with adjacent cell values [duplicate]

*Question is unique from Google sheets split multi-line cell into new rows (+ duplicate surrounding row entries) in that the parse is required in three separate columns rather than just one. I have a ...
0
votes
3answers
13k views

Why can't I set username for a Facebook Page?

When I go to http://www.facebook.com/username/ I can only see a drop down list with my pages but no input field where I could enter my desired username. What can be wrong? Are there some restrictions ...
0
votes
1answer
78 views

Validate that a web application has used a specific hash function for its certificate

What is the process for verifying the hash function that was used to create a web applications certificate? I ask because there apparently has been some issue with the MD5 hash function wherein ...
0
votes
2answers
2k views

Twitter no longer posts to Facebook page

I have 2 Twitter accounts and 2 Facebook pages. Everything was working fine all my tweets was posted to each Facebook page automatically until around 11 April 2013. Is there anything Facebook ...
0
votes
1answer
121 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
1k views

Create chart with total for each score

I have a column within a Google Spreadsheet with values like this: 96 97 96 100 97 97 100 97 95 95 96 I'd like to add a bar chart where each bar represents one of the values and the height of the ...
0
votes
1answer
4k views

How to trigger a script in Google sheets when a value changes

I try to fire a script when a value in a certain cell or range of cells changes. (it's not changed by the user, so I can't use onEdit) I've tried to use onChange, but this doesn't fire my script at ...
0
votes
1answer
553 views

“Never Show” missing on some contacts in Gmail chat [closed]

Similar to https://webapps.stackexchange.com/questions/tagged/chat, I'm trying to remove some contacts from my Gmail chat list. But for some of my contacts, there is no "More options" pull-down menu ...
0
votes
1answer
35 views

Find song and artist names with special characters in Google Play

When I try to use Google Play's search functionality to find special characters such as "-", "." or "[" it doesn't filter results by these characters. How can I search for songs and artists that ...
0
votes
1answer
361 views

Open Facebook group, but restrict user posting

We have a group that we have been using to basically run a D&D game. It's a closed group, and we want to open it so that the general public can follow the progress. However, since this is a ...

15 30 50 per page