All Questions

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

Create a hyperlink from two columns, one with title and one with links, then retain only the hyperlink without losing the references

Demo sheet here. Say I have two columns, one with string literal names, and one with links (in text form) A B Restaurant 1 http://www.link1.com Restaurant 2 http://www.link2.com ...
0
votes
1answer
5 views

Can I use photos on my personal google drive account for my business website?

Hi I am thinking of images that are used on my website on to the public folder of my google drive account and access it using <img src="some.gdrive.link.com">. Can I use google drive in such way ...
0
votes
1answer
16 views

How can I set up Google Authenticator (TOTP) for 2-step verification on my Google account?

I want to set up a TOTP tool like Authy (or Google Authenticator, 1Password's TOTP support, etc) on my Google account, which works the same way as Google Authenticator. However, I can no longer find ...
0
votes
0answers
1 view

Mailchimp: fields in contact list “disapeared”. List only displays the fields used in contact form

Weird behavior! Certainly after I build the contact form for my website, all the fields not used in the form "disappeared" from my contact list. Any idea why? And how to recover these "hidded" fields?
2
votes
3answers
25 views

How to filter out a long list of sites from Google search?

I have a list of sites I would like to permanently exclude from Google search results. These are the large family of sites plagiarizing (and some of them garbling with machine translation) Q&A ...
2
votes
1answer
32 views

How to add every Sunday in sequential order with 3 blank cells under each date?

How to add every Sunday in sequential order with 3 blank cells under each date? For example: March 22 Blank cell Blank cell Blank cell March 29 etc etc
0
votes
0answers
13 views

Recommended to enable setting to insert this signature before quoted text?

I am unclear about the Gmail signature setting to insert this signature before quoted text in replies and remove the "--" line that precedes it. Is that a recommendable practice or is it better to ...
0
votes
0answers
6 views

On outlook.com, how do I remove “Focused” and “Other” see all emails?

"Focused" and "Unread" don't assist me, as they don't show all emails. I'm asking about outlook.com, not the software Microsoft Outlook.
0
votes
1answer
11 views

Is it possible to set a timer on Google Sheets ui.alert()?

So I have a ui.alert that triggers and asks for confirmation before making an edit on a Google Sheet. javascript function confirmation(){ //Call Spreadsheet alert and give it a variable ...
0
votes
2answers
20 views

How do I limit search to a folder in Gmail?

In my Gmail, I want to search a keyword that appears only in a specific folder. Currently, it displays results from all folders.
-3
votes
0answers
11 views

Web App using barcode scanner [on hold]

For my final year project I have been asked to build a web based social media site for the university sports centre, which is a site that can be used to compare running times. They originally wanted ...
0
votes
0answers
4 views

Is there a way to only view the results for one individual term on google trends?

I'm trying to compare JavaScript package managers such as yarn and npm on Google trends. Based on Compare Trends search terms I'm under the impression that when I type yarn on Google Trends its ...
0
votes
0answers
30 views

search/match a date on Google Sheets using Google script and copy a source range to a destination range OFFSET from that date

I'm struggling with some simple copy/paste scripting in Google Sheets. I'm a complete scripting newbie. Advanced at Excel/Sheets. I have a "Today" data entry sheet. I have a "Program" sheet that ...
0
votes
1answer
12 views

sum of specific lines

How can you sum specific lines? When I add up specific lines such as A10:B20:C30 I get the entire column which doubles the figures. It is picking up the specific totals plus the individual columns
0
votes
0answers
3 views

Possible to receive notifications for new customer orders?

Is it possible to track and watch new incoming customer orders on Google payments centre?
1
vote
1answer
20 views

Adding missing dates to Google Sheets

I'm pulling data from HubSpot to Google Sheets via 3rd party connector. I have a raw data set on Sheet 1 and then I'm pulling certain data from Sheet 1 to other Sheets with QUERY function. For ...
2
votes
0answers
5 views

Vast discrepancy in distribution when I add segments to Google Analytics data

I am using Google Analytics for a multilingual website. I recently started digging deep into the pageview data and found something really peculiar. My pageview data as well as unique visitors have ...
0
votes
0answers
14 views

Ownership of Facebook business page

We recently purchased a local business that has a business Facebook page. They old owners can not figure out who the admin or owner is to transfer ownership to us. We have legal documents showing we ...
0
votes
1answer
16 views

reference cell as sheet in criteria in countif formula

I have a countif formula that gathers information from another sheet. =SUM(COUNTIFS(test!A:A,{"Story","Task"},test!D:D,{"In Progress"})) The sheet is named test. Is there any way I can write test ...
0
votes
1answer
18 views

List all sheet names - Google Sheets

I have a Google drive spreadsheet with 20 sheets. Is it possible to list all the sheet names, in an index sheet?
0
votes
1answer
45 views

HELP PLEASE! How do I regain access to Facebook account?

Facebook is trying to make me verify my account with my phone number (which I don't want to do) but I need my account! So what are some (free) easy ways I can get around this without a mobile number?!!...
0
votes
0answers
4 views

Is it possible to reply to a mention by email?

Slack is sending those handy emails but there doesn't seem to be a default way to directly reply. Is there any hack available for that?
0
votes
0answers
2 views

How can I watch for new submissions on the Support tab?

Is it somehow possible to track new submissions on the support tab of an extension on the Chrome Webstore?
0
votes
0answers
5 views

How to make my Google My Business listing appear on Google Maps?

I've followed some guides on the internet including this one. However, when I searched using the key words I put in my listing, my Google My Business listing did not show up in the result list. I ...
0
votes
0answers
18 views

Include filename of source spreadsheet

I have 2 spreadsheets for 2 employees and I combine them into 1. From employee 1: From employee 2: I use importrange to combine the sheets. I also know now how to get the spreadsheet file name by ...
1
vote
1answer
20 views

How to link a text box in Google Slides to a cell value in Google Sheets?

I have a weekly Slides presentation that summaries result from Sheets. I don't want to have to edit the presentation every week, copying and pasting text from one webapp to another. Since it is ...
2
votes
1answer
18 views

Column of numbers. If one of the numbers is equal to another number in the column, excluding itself, put a “T” in front of it

I'm so close to getting it. I've tried a couple things. My wheelhouse is python. Unfortunately Excel is not my forte. =IF(OR(U2=(U3:U32)),"T"&U2,U2) First attempt. If U2 is in U3:U32, put a T in ...
1
vote
1answer
13 views

YouTube: is there a way to get email notification ONLY when I upload a new video?

I'd like to get the notification when the upload is done. But I don't want any other emails from YouTube.
1
vote
1answer
20 views

Output counted list with extra qualifier

I currently have a table with the following columns: Comm ID Item Name Months Orichalcum Tempest Jade Green Iron Weltsilver Ambergelt Beggar's Lye Dragonbone Iridescent Gloaming ...
1
vote
1answer
15 views

Syntax for Unicode characters in regexes in Google Sheets?

What's the syntax to use for general Unicode characters in regular expressions in Google Sheets? Use case: When using REGEXREPLACE with user submitted strings in Google Sheets, I have come across a ...
3
votes
2answers
23 views

Conditional Formatting Column C when Column B is not empty

I am trying to get column C to turn green when column B has a value in it. I think there is a bug because the custom formula below is not working.
0
votes
0answers
9 views

YouTube search API response indicates results found, but actual results list is empty

I'm making a Search: list API call I'm passing it the following parameters: Array ( [maxResults] => 1 [q] => GuyATL YFN Lucci The Game [type] => video [order] => ...
0
votes
0answers
7 views

How to see all the groups my page join?

The URL https://www.facebook.com/pg/mypagename/groups/ can show a portion of the groups my page join, but how can I see all of them? This Facebook Help Center's article How do I see a list of my ...
1
vote
1answer
29 views

Writing a macro to create a new tab and name that tab based on a cell value in Google Sheets

I would like to have a Macro that generates a new tab and names that tab based on a cell value. There is a tab called 'Dashboard'! on which the user enters information in assigned cells. Afterwards, ...
1
vote
1answer
19 views

How to combine same value for Google sheet query?

I am trying to create a separate tab in my Google sheet where I can filter the Trainer to see which days they will be conducting a Day 1 and Day 2 Training. Day 1 Training: =iferror( query('...
0
votes
0answers
9 views

Add trip manually in Google Maps or Google Travel

With the Google Trips app I was able to add a Trip manually and add related e-mails to it. Now I booked a trip and got a reservation e-mail but Google did not create a trip for that. I cannot find a ...
0
votes
1answer
9 views

« youtube.com/watch/ » end time

I distinctly remember having seen a parameter under « youtube.com/watch/ » which indicated when a video was to stop playing, much as the "t" parameter indicated the starting point. It had a multi-...
1
vote
0answers
6 views

What if my Quora answer is not mine?

I got an upvote to a question about Queen's Bohemian Rhapsody, so I looked at the answer I gave. It's NOT my answer!!! I never liked the Bohemian Rhapsody, but whoever answered the question seems ...
0
votes
0answers
8 views

Facebook tags are not seen in news feed by any of my friends

Everytime someone tags me in a picture my friends can see it only if they get into my facebook profile. But anyone is seeing that I was tagged in their news feed. So no one ever even notes the ...
-1
votes
0answers
8 views

Conditional Formatting - Custom Formula

I have 4 columns I want to work with in creating conditional formatting. I have Column D with the estimate amount given to a customer. In Column E I have drop down choices containing of only "Yes" ...
0
votes
0answers
6 views

How can I opt out of Facebook invite notifications?

Like the one shown below. I don't want to receive any invite notifications at all.
0
votes
1answer
13 views

Why do birthdays show up in my calendar?

Where can I modify if/how birthdays show up on my Google Calendar desktop version? I can't find any setting for that. Below an example of such a birthday event that I haven't created myself. I don't ...
-2
votes
0answers
7 views

Need to generate an image file from html/css/js on the server-side! [on hold]

I'm not a web development expert. I’m having a website built with a developer and we’re looking for a solution to a problem. I need to generate an image file from html/css/js on the server-side. I ...
1
vote
0answers
10 views

Determining what type of search result is returned by Wikipedia

When you send a search to Wikipedia using the: http://www.wikipedia.org/search-redirect.php?search=George Washington URL, it seems like this function returns 3 different manifestations of Wikipedia ...
1
vote
1answer
18 views

Is it possible to see all followers of a Facebook account?

When I try to see all the followers of my Facebook account, after a few at the top which are randomly ordered, the rest is seen ordered alphabetically, and when I reach half of the usernames starting ...
0
votes
0answers
42 views

I am trying to work with Google App Script to auto respond to after hours emails [on hold]

I would like to have emails received to a particular inbox responded with a canned messaged after hours. Below is the code I've got so far. Is there something I am missing? I've tested but do not ...
2
votes
1answer
25 views

Dynamically reference data from multiple tabs and sort it

I've got a spreadsheet with multiple tabs of data. The data contains 2 columns, A = Categories, B = Quantity. I've created a copy of the spreadsheet HERE (please use file > copy) if you would like ...
1
vote
0answers
8 views

RegEx filter to merge different urls (PhpBB) [migrated]

I have a phpBB forum and I want to merge the different urls Google Analytics throws up into 1, eg: /forum/viewtopic.php?f=16&t=6457 /forum/viewtopic.php?t=6457 /forum/viewtopic.php?f=16&t=...
1
vote
1answer
11 views

How to change primary profile?

I am unsure how to change the primary profile on LinkedIn. In my case below, I'd like to change my default profile to English.
1
vote
0answers
8 views

How to train GitHub's “explore repositories” recommendations?

I find the the "explore repositories" feature in GitHub useful to discover new tools and libraries - or at least I used to find it useful. As of mid-summer 2019 it seems GitHub changed its algorithm ...

15 30 50 per page