All Questions

Filter by
Sorted by
Tagged with
1
vote
1answer
2k 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
85 views

What does the Cognito Forms “entry limit” cover?

Is the entry limit on logins/plans based on numbers per form, or total numbers across all forms?
1
vote
1answer
333 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
656 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
318 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
732 views

Google App Script - changeType “REMOVE_GRID”

I'm using a Google spreadsheet. I'm attempting to create an onChange trigger that will activate a script when any sheet is added or deleted. I was able to get the script to work when a new sheet is ...
1
vote
3answers
8k views

Image beside text in Gmail signature?

I found here how to copy an HTML signature to a Gmail address: Insert HTML markup into Gmail signature I would like to get something like this:(image is hosted on a server): However, I did not ...
1
vote
1answer
987 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 ...
1
vote
3answers
3k 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
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
1answer
69 views

Summarize the best options in another table

I need help to create a sheet for a game. I am providing the INPUT, and I would like to create the OUTPUT in another tab (do not consider the colors, its just for ease of understanding): Mainly, the ...
1
vote
1answer
64 views

FILTER() Is not returning consistent results

I'm having some issues with FILTER() not returning consistent results, below is an image detailing the inconsistencies. When filtering for 3:30 PM I only get 2 results instead of 3. When filtering ...
1
vote
1answer
551 views

Create incrementing number field in Cognito Form

Is there a way to have forms create an ongoing numbering field. I want to have my forms numbered automatically when they are filled in by a user. Any ideas?
1
vote
1answer
196 views

How can I share posts from GoogleReader to Google+ [duplicate]

Possible Duplicate: Send to Google Plus from Reader How can I add Google+ to the custom "Share" items in GoogleReader? According to this question and lack of resolution, it is not possible? ...
1
vote
0answers
464 views

Migrating Facebook app from a personal account to a corporate account [duplicate]

I have an app on Facebook that is currently associated with my personal account. I want to move this app over to some sort of "entity"/corporate account. To better explain the situation: I'm working ...
1
vote
2answers
113 views

How to sort incrementally in Google Sheets

Background I'm making a spreadsheet that will plan out attendees for a wedding. There will be separate halls for men and women, and we are debating which age groups should be invited. Right now I ...
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
1answer
3k views

Google Keep won't load properly in Firefox

Google Keep will not function for me anymore in Firefox. When I go to http://keep.google.com, as soon as the page finishes loading I get a little dialog that says You've been signed out. Please ...
1
vote
2answers
1k views

xpath to get non-distinct parent node data for each child node

Google Spreadsheets has an IMPORTXML function, which I am trying to use to maintain a list of TV episodes, based on the API at http://services.tvrage.com/feeds/episode_list.php?sid=3183. I am trying ...
1
vote
1answer
840 views

Where are Labs for Google Maps desktop? Are they gone?

Are the lab section for the desktop version of Google Maps gone? Googling only returns old results, although I found this link https://maps.google.com/?showlabs=1 but it does not seem to make any ...
1
vote
0answers
3k views

How to delete all the Google+ stories (auto-awesome images) created while backing up from Android

I enabled recently the backing up of my images/videos on my Android 4.4 Nexus 5 since it was suggested to me, as described here http://techcrunch.com/2014/02/25/google-quietly-begins-pushing-its-photo-...
1
vote
0answers
248 views

Change the admin user for a Trello organization?

How would I go about changing the administrator user to someone else? Recently the person who signed up our organization for Trello left. We are trying to reach them to see if they can transfer the ...
1
vote
2answers
12k views

How to sum values by month

I'm trying to have my spreadsheet to sum up values by month. Note that the dates are not organised chronologically. I've tried the solutions showing here but they are not working for me. I'm not ...
1
vote
2answers
2k views

Twitter 'confirm email' message won't go away after trying everything I could find online to try

Two other people on this forum have asked this question and I have tried the advice given in both responses, but it still won't work for me. I've searched everywhere else online and cannot find any ...
1
vote
1answer
1k views

A formula to copy and past data between sheets as values only

In a google spreadsheet I have a query that gets data from different sheets (tabs) and pastes them into a Master sheet (tab): =query({Sheet1!A:H; Sheet2!A2:H}, "Select * where Col1<>'' ") Data ...
1
vote
1answer
4k 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
1answer
2k views

See the number of comments in a Google Doc

How can I see the number of comments made on a Google Doc? Apart from manually counting them, of course...
1
vote
1answer
4k views

SPLIT function in Google Spreadsheets with OR statement

I want to use the split function, but with different delimiters. I thought of something like this: =SPLIT(A:A;OR("-","&")) but it doesn't work. Is it possible to have Boolean statements within a ...
1
vote
1answer
1k views

Two yes-no questions, if both anwers are yes go to section 2 and 3, will skip section 2

I'll make a survey with Google Forms and add two yes-no questions. If both answers are "yes", they must be navigated to sections 2 and 3 of my survey. Below you could find a scheme: ------------------...
1
vote
1answer
2k views

How to add user to an existing post in Google Plus?

I shared a link with friends and then realized others people might be interested by the content. But I don't see any button that allow to update/edit sharing list. I know I can re-share the posts, ...
1
vote
2answers
1k views

Conversion from Excel to Google Spreadsheet - sum across sheets

I'm importing an Excel spreadsheet into Google Drive. Its a huge spreadsheet, and overall Google spreadsheets has converted everything, except the following: There are a few cells with formulas like ...
1
vote
1answer
418 views

How to customize eBay's End of Auction emails?

As a seller, I'd like to customize eBay's End of Auction email. I couldn't find any up-to-date information about it apart of some old eBay FAQ page which says: To customize your End of Auction email, ...
1
vote
1answer
81 views

My G Suite Gmail personal emails to people are being sent to spam

I was one of the early adopters of the free G Suite (formerly Google Apps) package from Google. So I set up a little custom domain and email for my family. It's limited to 50 users but that's way more ...
1
vote
2answers
277 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
671 views

Why is OkCupid showing me matches who live more than 5 kilometers away?

I'm using OkCupid, an online-dating and friend-matching site. I have set the site to show only matches within 5 kilometers of me. Unfortunately, the site seems to be showing me lots of matches who ...
1
vote
1answer
234 views

Organizing and filtering Twitter data [closed]

I follow a lot of people on Twitter, normally I use the web interface. I used to follow a lot more, but a few months ago, I organized my follows into lists. I ran into two problems, I ran out of ...
1
vote
0answers
558 views

Tell facebook to ignore event invite notifications from a friend

I keep getting facebook event invites from a friend. These are events I mostly don't bother about. I'd still want to view the event details and all, but I don't want to get notifications regarding it. ...
1
vote
1answer
866 views

Can't upload APK to GitHub releases

It was working five minutes ago, but now for some reason I can't seem to be able to upload an APK: Has it just become impossible to upload APK files to GitHub releases? Or am I doing something the ...
0
votes
1answer
583 views

How do I export my blog from Blogger? [duplicate]

Possible Duplicate: Export blog entries from Blogger Apparently I have used up all of the space that Google will give me for free for photos on my blog but I don't want to delete past posts. How ...
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
1answer
210 views

Google Sheets - summing numbers across a spreadsheet depending on the Column header

I am looking to automate our timesheet process. Each staff member has their own separate Google Sheet which has the dates down one column, and then a varying number of columns named after different ...
0
votes
1answer
48 views

How to send email to a person selected from a dropdown menuwith all answers of a response of the form submission?

I want to notify mentors if they're selected by a user on a Google Form. The names of the mentors are in a drop-down menu in the Google Form. This is the form: https://forms.gle/iNuA5nB2J9koKhXt6. I'...
0
votes
2answers
33 views

Sync Photos and Videos with Google Backup and Sync tool for Windows

I am using the Backup and Sync app from https://photos.google.com/apps to backup my Photos and Videos to Google Photos, it works but the problem is I am uploading 1TB of photos and videos and the ...
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
1answer
5k 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
163 views

Print Playlist from YouTube Music

I want to print a list of songs (with artist, album, and duration) from my YouTube Music account. There is no easy way to do this from the app. Doing print-screens as I page through a long list of ...
0
votes
1answer
148 views

Gmail account storage full

I am having a Gmail account and this account is configured with window service.This window service read mails with attachments from inbox and send update back to user after particular interval. ...
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
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
3answers
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 ...

15 30 50 per page