All Questions

1
vote
1answer
6 views

Sum value in cells that contain both number and text

I need to sum a range of cells with text in them. Example: a1= "25,00 market" b1="24,00 credit card" c1="75,11 food" a2= "10,00 sweets" b2="9,00 market" c2="24,00 keyboard" I want to sum ...
0
votes
1answer
4 views

Combining `ARRAYFORMULA` with functions whose arguments can be rectangular ranges

I mean to concatenate several columns, so use of CONCATENATE is preferred over & (here I post an example with only 3 columns). For instance, D1 would contain =CONCATENATE(A1:C1). Then I would copy ...
1
vote
0answers
4 views

How to resend a request for a recommendation on LinkedIn?

I keep getting this message when I click on request a recommendation: You have already sent George a recommendation request for this position How can I resend it?
0
votes
0answers
12 views

Get data from a column and paste it to another sheet

I saw this script in one of the questions here and modified it a little: function myFunction() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet1 = ss.getSheetByName("RAW"); var ...
1
vote
1answer
11 views

Google Forms sending me duplicate email on automatical email

So, I've used this code, just reworked for my needs: Can Google Forms send emails automatically? The problem I have is that the account that sends those emails also receives them. Is there a way to ...
0
votes
0answers
4 views

Is it possible to create a playlist with the videos of a YouTube channel ordered by date relatively easy? [duplicate]

I want to watch all the videos from a YouTube channel from the older ones to the new ones. I would like, if possible, not having to manually click each one of them to reproduce them, but after one ...
-1
votes
0answers
8 views

Why are certain sensitive words in rap songs on youtube censored?

I just noticed it in one song, thought nothing of it, and then in another it was really obvious aswell. For reference, in this one: https://www.youtube.com/watch?v=85sC2xLIViU E.g. the words "nigga" ...
1
vote
0answers
8 views

How do I delete the left bottom Gmail notifications that I've deleted an email?

Every email I delete gets a reminder on the left bottom of screen that I've just deleted it. Is there a setting to make these notifications not appear?
-1
votes
0answers
4 views

How do I (efficiently/going through not more than one or two pages), set meetup to only send me an email when I get a message?

How do I (efficiently/going through not more than one or two pages), set meetup to only send me an email when I get a message? And not send me an email for any other reason. When I go to the main ...
0
votes
0answers
7 views

Prevent Receiving from Google Photos

When photos are shared from Google Photos, if the recipient is a Gmail user, they are by default shared through Google Photos rather than email to the Gmail account. Is there any way to prevent people ...
0
votes
0answers
9 views

Filter all email using plus addressing

I am looking for a way in gmail (technically google apps for business I think) to filter all email which is delivered to an address using plus addressing. I want to tag all email to firstname.lastname@...
0
votes
1answer
13 views

Run a Script When Tab Programmatically added to a Google Spreadsheet

I'm trying to pull data from an Adwords report to a Google Sheet through an Adwords script. This will be done on a daily basis. Every time the Adwords script runs, a new tab is created (and an old one ...
1
vote
1answer
17 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
1answer
13 views

Combine Custom Formula with Colour Scale in Conditional Formatting

In Conditional Formatting in Google Sheets, I'm wondering if it is possible to combine the Format Cells if - Custom Formula is with a Colour Scale? It would appear not, but is there a clever ...
3
votes
0answers
30 views

How to backup emails from Gmail without the attachments and images

I am trying to backup my Gmail because our company will be closing our business account (cost cutting) and expect us to use personal email instead. I tried Google archive, but it ends up 20GB+ even if ...
-1
votes
0answers
7 views

Disposing old IT equipment to employees - Looking for web app solutions to make the process easier! [on hold]

So our company disposes old IT equipment such as laptops and tablets to our employees for a very steep discount. This year we have a lot of assets to get rid off and was thinking of implementing a web ...
1
vote
0answers
11 views

Move imported email back from Gmail to Outlook

I use my Gmail to import email for another email account. Is there a way to use Outlook to retrieve those emails back in an automated fashion or are they now in Gmail permanently?
1
vote
1answer
18 views

Conditional IMPORTRANGE

In Google Sheets, I'm using IMPORTRANGE to pull in data from to a large sheet. One field is a dollar amount. I would like to import the dollar amount and replace any zero amount with a specific ...
3
votes
1answer
102 views

How can I get back a Gmail account I deleted forever 10 days ago?

10 days ago I deleted forever by mistake a Gmail account that I need to recover (in the next couple of days). Is this doable? And if yes, how?
2
votes
0answers
17 views

How to Create a Google Drive Index

I have a Google Drive drive with multiple folders and subfolders I want to make an Excel index that contains a table of the folder name, and the path of the folder (its web address) I saw that there ...
-2
votes
1answer
8 views

No option to reply to calendar invitation

I received a google calendar invite but there was no option to reply "yes, no, maybe"
0
votes
1answer
16 views

Gmail displaying images even when it says “Images are not displayed”

How is this possible? Doesn't the circled part of the screenshot below seem false given that there is then an image in the body of the email? UPDATE in response to comment: When I inspect the HTML, ...
0
votes
0answers
27 views

Unable to sign in to our gmail account [duplicate]

Hi Team, I am facing the below issue.I forgot my recovery email and recovery phone number.But i know my email id and password correctly,but i am unable to login to my account.Any help would be much ...
0
votes
0answers
8 views

Google Sheet filter protected columns

I have a problem with google sheet. The situation goes as follow: Columns A B C D A: ID, Every one have access to the column and can edit. B: Only team 1 have access and can edit. C & D: Only ...
1
vote
0answers
14 views

POP and SMTP server error messages

My Outlook fed by Gmail account won't accept my password. POP and SMTP boxes keep popping up asking for a password. How do I resolve this, please?
0
votes
0answers
20 views

Find the corresponding date of first cell with a number

I am trying to create a resource/capacity planner that allows me to play around with when team members are assigned to the project. I want to be able to add in a number on the days they are assigned ...
1
vote
0answers
11 views

How to embed a Github Repo Insight page to a new Google Site?

I have a private "new google site" where I would like to have an overview of several metrics. One of them is the number of open PRs on a private repository in Github. I can insert an embed github ...
1
vote
0answers
21 views

How can I add “complex” URL attachments to a card via Trello’s API?

On Trello's API documentation, it is said that an urlSource parameter can be included while creating cards. This can be found here. I'm testing the API with JavaScript. The problem is that Trello ...
2
votes
1answer
24 views

Processing data from multiple cells and comparing results with another cell

For most orders, I have multiple deliveries under the same recipient ID and I need to compare whether everything ordered is really delivered. All products are divided by a comma and have always the ...
0
votes
0answers
4 views

Cognito Forms - How to specify a date in a date range or notice when a specific date occurs in a date range

My clients book our services on a short term basis of up to 90 days. If a public holiday occurs during the requested period the client needs to: a) be informed that there is a public holiday in their ...
1
vote
1answer
20 views

Formula for combining text if there are duplicate numbers

I have a table to combine text with conditions if in column A there is a duplicate number, then in the text in column B combined. The formula that I have made like this: =IF(COUNTIF($A:$A,A2)>1,...
1
vote
1answer
11 views

Is Google Maps's “Popular Times” feature only for restaurants?

Is Google Maps's "Popular Times" feature only for restaurants, or is there a way to enable/view it for non-restaurants?
1
vote
1answer
9 views

How to SUMIF depending on another column's value and REGEXEXTRACT

I'm trying to use SUMIF and REGEXEXTRACT, i want to get a total sum of the description only where paid out is not blank and the description value needs to be multiplied by value in paid out so on the ...
0
votes
0answers
22 views

Prevent Gmail right-click from opening a New Message panel

If an email message contains an email address in the body, Gmail automatically converts it into a mailto: link, which is helpful. And many times each day I've enjoyed being able to right-click a ...
0
votes
0answers
31 views

Google search data

I went today through the process of deleting my entire data history from Google's servers. I went to myactivity and browsed through EACH TAB and clicked DELETE ALL ACTIVITY. I even went through ...
1
vote
3answers
44 views
1
vote
1answer
11 views

Nested IF with FIND

I have a list of transactions in column A that I want to categorize. I want to search A1 for, say, "Shoprite" and if found return "Groceries", otherwise search for "Shell" and return "Gas", otherwise ...
-4
votes
0answers
10 views

BMW 2012 X5 problem [on hold]

Is there a reputable dealer in the Orlando area who can work on BMW X5's who can repair an issue with the fuel tank and replace the head cover?
0
votes
0answers
7 views

Copy template to a new sheet referencing a cell number that is to increase incrementally

I have a template sheet that I would like to be able be able to copy with a unique name. Needing a single function to execute these steps: The document containing TEMPLATE is opened Button is ...
0
votes
0answers
10 views

Fractional formatting and math

Looked over the possibilities for help and coming up empty. I have written a spreadsheet which does some routine calcs for me. The problem comes in the formatting of certain cells. What I have: A ...
0
votes
1answer
33 views

How to correctly show contact names in Gmail

Most of my contacts are businesses, I was able to find the field "Archive as" in my Google Contacts which helped in organizing them. However when entering a contact in Gmail, it still shows the ...
0
votes
1answer
30 views

How do I lock my Facebook profile?

I have found some Facebook accounts if someone is not my friend, it shows "This profile is locked". I want to do same with my Facebook account. How can I do that? I have seen in other's accounts a ...
0
votes
0answers
7 views

Why is my Google Optimize reporting not matching Google Analytics?

Reporting of click events on images in Google Optimize isn't matching Google Analytics. Has my a/b testing experiment been configured correctly? I've created an Optimize experiment where I've ...
0
votes
1answer
10 views

How accurate is GitHub traffic analytics?

It seems to me that GitHub analytics is not very accurate. I have some repositories with 1-3 visits in 14 days, and one that gets 5-20 visitors a day. Even for repositories that get little to no ...
0
votes
2answers
24 views

How to get price of specific cryptocurrencies at specific times?

I have an assortment of cryptocurrency transactions over time. Various currency pairs at various prices. I need to figure out what the price of those currencies was, in Bitcoin, at the time that I ...
0
votes
0answers
7 views

How to Design a web application to dynamically update table from a file [on hold]

I would like to develop a web page that will have a table dynamically updated from different files on different server. So in order to maintain environment details we need a web page with different ...
1
vote
1answer
22 views

How to return all values (horizontal array) in B that has the same key stored in A?

Sample Sheet 1: A B 1 a x 2 a y 3 a z 4 b i 5 b h 6 b w Formula result, in Sheet 2, I am looking for: A B C D 1 a x y z 2 b i h w
0
votes
1answer
15 views

Google Docs copy paste formatting / indent question

So say I am taking a YouTube transcript, and copying the whole thing, and then pasting it into a document. The way the transcript is set up with YouTube it's layered like every 5 seconds so its lines ...
0
votes
1answer
32 views

Getting data from another Google sheet that isn't in the same order

I have a very basic knowledge of deeper functions of Google sheets and solving this has been a little bit of pain in the butt so far. I have a spreadsheet A column A contains ID column I that has ...
0
votes
1answer
4 views

Azure DevOps Organization Setting

There are multiple organizations listed when I go to our Azure DevOps. I own one of the orgs and manage all projects for the company there. I would like to move my Organization to the top of my orgs ...

15 30 50 per page