All Questions

Filter by
Sorted by
Tagged with
1
vote
2answers
706 views

Send a google form result to an email

I need help with the google form. The problem is this: I want to receive an email with its results for every user who completes the form. For example, if you had a form that required email, name and ...
1
vote
4answers
457 views

Google storage is out of space

I deleted all my photos from Google+ Photo, but it still don't show space is free. I also deleted all from my recycle bin in Google Drive, GMail and Photos recycle. How can I to fix this issue? May ...
1
vote
1answer
1k views

GMail chat list doesn't show the “More options” or “Caret” icon [closed]

I was trying to organize my Gmail chat contact list, I remember that previously there was a "More options" button and then it was replaced by a "Caret" icon which open a dropdown menu with the option ...
1
vote
1answer
3k views

Trigger function when IMPORTRANGE() is updated

I have a sheet (sheet-A) that gets it's information from another sheet (sheet-B) using IMPORTRANGE(). In sheet-B I have a function that formats cells based on the a value in the row. At the moment I ...
1
vote
2answers
102 views

Google spreadsheet: reformat event data (several dates on one row/event) to create a .csv file (one date per row/event)

I currently have a list of several recurrent events, with dates of recurrence on the same row. I hope to create a .csv file for importing into calendars, so would like to have each recurrent date on a ...
1
vote
1answer
1k views

Limiting range in OnEdit timestamp script

I would like to be able to limit the range of cells being assessed by this script to the first column. Apply the timestamp to the last column and only have the script run on a specific sheet "Short ...
1
vote
0answers
512 views

Valid user blocked from Google Groups

We have a Google Apps platform, and I have created a google group there, but there is a particular user with a regular, working Gmail account whom I cannot add to the group. Some email addresses ...
1
vote
2answers
560 views

Restrict ImportRange to only visible rows [duplicate]

I need to restrict the ImportRange function below to show only visible rows as some of the rows are filtered and some of the rows are grouped. =importrange("WorkbookID","Sheet1!A2:K13285")
1
vote
2answers
831 views

Finding and repairing broken section links on Wikipedia

I want to find broken section links on Wikipedia so that I can repair them. How can I find links to non-existent sections on Wikipedia (such as [[Google#fbffgfd]]) and replace them with working links (...
1
vote
0answers
136 views

Importing online docs into SkyDrive

I hate to download-upload. It is stupid. The acceptable approach is the one we have to insert images into SE posts: there is an option to choose between "from my computer" and URL. Now, I want to know ...
1
vote
1answer
2k views

Changed name in Google but still old name in Google

I changed my name in Google for privacy reasons but if I search for my real name in Google I see the following result: Real Name - Google+ from Fake Name Fake Name hasn't shared anything with you......
1
vote
2answers
623 views

Is there a workaround for Google Bookmark search problems?

I'm not sure if anyone else has come across this, but I'm getting incomplete results when searching my Google Bookmarks (not Chrome bookmarks). I have a link with the title including "headlights" ...
1
vote
1answer
30 views

Can you post to a Facebook group with a Facebook page which is not admin of that Facebook group?

So now you can post to a Facebook group with a Facebook page which has been set as administrator of that Facebook group. But can you do the same with a Facebook page which is not administrator of that ...
1
vote
1answer
142 views

Set from address based on sender to address

I've got a number of email addresses forwarding to my gmail. I've also set up in my gmail so that I can select my "from" address to be these email address which forward to gmail. However, sometimes I ...
1
vote
2answers
182 views

Date fields that refuse to be parsed/formatted

I have some very mysterious date fields in a huge (600 000 records) CSV file which absolutely refuses to behave. They come up aligned left, and conditional formatting shows that they cannot be seen ...
1
vote
2answers
1k views

Using an email address with two different names in Gmail? (as two aliases) [duplicate]

I've setup Gmail to use my own email address, like info@mycompany.com. When using this address as from-address, sometimes I want it to prefix with my personal name, and sometimes my company name. I ...
1
vote
1answer
3k views

Auto populate a field with the user who made the change [duplicate]

This is what I use to allow Google Sheets to auto-populate the date/time in column "N" whenever any cell in that row is updated. function onEdit() { var s = SpreadsheetApp.getActiveSheet(); var ...
1
vote
2answers
3k views

Google Sheets, formula, reference to variable sheets

Google says in their web help how to reference data from another sheet, but what happens if what I need is to make the reference depending on my fields on the current sheet? Let's say I have a sheet ...
1
vote
3answers
2k views

How do I transfer documents from Google Apps to another Google Account outside of that organization?

I have a Google Apps account as part of my school, but I'm going to be graduating shortly. I want to transfer ownership of my documents to my personal Google Drive account. However, when I do so from ...
1
vote
1answer
2k views

Highlight cell border in Google Docs

I'm trying to create a table in Google Docs. I need a header row at the top and a similar column on the left side. To distinguish these from the rest of the table I am trying to embolden the line ...
1
vote
1answer
105 views

Is it possible to use the contents of a cell in a custom conditional formatting rule in Google Sheets?

For example, given the sheet below: I'd like the background colours of columns B-D to change automatically when I update the values in column A Is that possible? I'm looking for a solution that will ...
1
vote
1answer
265 views

Auto-update other sheets

Responses are automatically added to the sheet Form Responses. I want to apply certain formulas in a sheet called Student Answers. However, Student Answers doesn't auto-update from the submitted ...
1
vote
1answer
7k views

Pull information about each game from boardgamegeek.com

I am trying to create a Google Sheet to combine several peoples' board game collections. I want the sheet to pull information about each game from boardgamegeek.com. Example Page: https://...
1
vote
0answers
2k views

Exporting and Importing various Amazon lists; Shopping Lists, Wish lists, Idea Lists, Default List?

This question circa 2011: How to export/download my Amazon wishlist? Now, we have multiple lists in addition to the default wish list, that we make and change various times. At times we wish to ...
1
vote
3answers
3k views

How to make Blogger show the last modified date of any post? [duplicate]

How can I make Blogger show the last modified date of a post? When I edit an old post in Blogger, is there anyway to list the last modified date somewhere? anywhere?
1
vote
1answer
605 views

How to create an automatically updating Google spreadsheet with information from Steam?

How would I create an automatically updating Google spreadsheet containing information about Recent Activity in Steam? Table must look like here: But the hours column must automatically updating ...
1
vote
2answers
24 views

How do I get this formula to increment by 1 per 25?

I need my formula to increase by "1" for every "25". I wrote the following formula, but it does not work: =SUM( IF(O11<25,0, IF(O11<50>21,1, IF(O11<75>51,2, IF(O11<100>76,3, IF(...
1
vote
2answers
68k views

How do I enable comment replies on my Facebook page?

In the last two month I have seen Facebook pages that have a comment reply button but my page doesn't have it. How can I enable this feature?
1
vote
2answers
252 views

Google Photos is using all of my quota even though I'm uploading as “High quality”

I have a 25 GB limit and have been uploading JPEGs to Google Photos. I have set it in Google Photos options so they are uploaded as High quality (free unlimited storage), and verified that they are ...
1
vote
1answer
162 views

Google Sheets countif attendance sheet, quarterly report

I have a Google Sheet that I use to track attendance at an open lab that I run. Each quarter I put together a report where I count the number of people that attended that quarter. If I just use the ...
1
vote
0answers
175 views

How to move emails between Gmail accounts?

I have a couple of Gmail accounts (one personal Gmail and a couple of work Google Apps accounts) and sometimes, I mistakenly send an email and start a conversation from the wrong account. What is the ...
1
vote
1answer
357 views

How Can I Get Rid of the “This Person” Follows Tweets?

My Twitter feed gets filled with random tweets about "this or that person follows" and I get random tweets that I don't want. I'd rather have my feed filled with people I follow and not have to scroll ...
1
vote
2answers
1k views

Getting non Facebook friends to like my page

Can my non Facebook friends like my page? Can I invite people to like my page that are not friends on my personal Facebook page? I don’t want some people to be my friend but I want them to like the ...
1
vote
2answers
1k views

Print all Gmail messages between specific dates

Is there a way to print (or export, or save as PDF) all mail messages between specific dates in Gmail? I realize I could probably do it through an email client, but I would rather be able to through ...
1
vote
1answer
95 views

How to add a date to a cell next to an cell with an imported value

In column A I have a value added each day from the tab/cell TOTAL/A1 by this script: function dailyLog() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sourceSheet = ss.getSheetByName('...
1
vote
1answer
2k views

How do I select unread messages in Gmail without having to click on the arrow next to the checkbox and then click unread?

A lot of the time the unread messages in my Inbox just need to be archived and I'd rather have a 'quick' way to do it that doesn't require hitting that small arrow next to the master checkbox and then ...
1
vote
1answer
4k views

Using AGGREGATE formula on Google Sheets - Finding the correct result based on 3 columns of criteria

It took me a long time to get this working on Excel, and just as I managed to do it, my company changed over to Google Sheets! I work for a packaging company, and we sell hundreds of different boxes ...
1
vote
1answer
646 views

Can the ip of the submitter be recorded in form data in Cognito Forms?

Need to record the ip on signature forms for added legality. Is this possible?
1
vote
0answers
3k views

Auomatically lock/protect a range or row based on date

Any one can help how to do a scripts for auto lock / protect range/row by date I have try but this script only lock a cell only ( cell M:M ) a = SpreadsheetApp.getActiveSpreadsheet(); var s = a....
1
vote
1answer
2k views

Using SUMPRODUCT with ARRAYFORMULA

I have the following random data in sheet one A orange D yellow C yellow B orange B orange C blue A yellow D blue C orange C blue In sheet two I use the following query function: A1=...
1
vote
2answers
373 views

Preventing certain words from appearing on a Google Sheets

Let's say that I have a big Google spreadsheet that multiple users have access to, and I'm not able to control which users have access to it. I have a concern for trolls. How would I prevent people ...
1
vote
1answer
3k views

Is there a way to generate edit response URL for Google Form?

I have a Google Form with a Google spreadsheet to store responses with columns: name, email, revenue, and a fourth column Id which is used to identify the particular respondent. I am trying to ...
1
vote
0answers
2k 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 ...
1
vote
1answer
329 views

Can I avoid using Gmail's category tabs and revert to the old interface?

Is it possible for me to return to the old Gmail screen without the categories tabs? Would my only option be to move to another email provider? I cannot understand most of the computer "language", ...
1
vote
1answer
290 views

Evaluate date inside a query

I am attempting to perform a query in Google Sheets, and one of the things I need to match is a date. I have seen other posts on this topic, but I am not having success. The advice that isn't ...
1
vote
1answer
1k views

Split columns in to rows in google spread sheets [duplicate]

I have following table: ID Event Event2 Event3 102 181 182 184 103 5 7 8 I want to convert in into: ID Event 102 181 102 182 102 184 103 5 ...
1
vote
1answer
139 views

Difference between Default Value and Calculate Condition

When making a hidden value question and filling in the Default Value with a question, CommCare gives me a warning. What is the difference here between Default Value and Calculate condition? And why ...
1
vote
3answers
2k views

Google forms script to delete responses counter

I have tried and combined a few pieces of script to delete rows, but this does not reset the counter. Help resetting responses using script would be appreciated. My copy sheet function, and delete ...
1
vote
3answers
178 views

Is there a way to find a site by an image they link to?

I have the URL for an image that I downloaded, and I'm trying to locate the site that linked to it. E.g. http://12345.blob.windows.net/random/abc123.jpg The image hosting site is windows.net. Is ...
1
vote
2answers
2k views

Whitelist email address for a Google Group

We are a free and open source software project. We set-up a Google Group for build results from services like Travis, AppVeyor, CodeFresh and Coverity. The list does not allow Public to post since we ...

15 30 50 per page