All Questions

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 ...

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 ...

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?

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 ...

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 ...

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 ...

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" ...

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?

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 ...

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 ...

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@...

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 ...

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 ...

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 ...

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 ...

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 ...

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?

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 ...

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?

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 ...

I received a google calendar invite but there was no option to reply "yes, no, maybe"

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, ...

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 ...

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 ...

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?

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 ...

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 ...

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 ...

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 ...

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 ...

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,...

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

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 ...

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 ...

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 ...

Sample data: A B C D E F 1 name handed in students assignments name missing 2 a 1 a 1 b 2 3 b 1 b 2 ...

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 ...

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?

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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

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 ...

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 ...

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 ...