All Questions

basically I've this "problem": I've the query =Query(Raw_Data!J$2:$BL,"Select J, Sum(U),Sum(V),Sum(W),Sum(X),Sum(Y),Sum(Z),Sum(AA),Sum(AB),Sum(AC),Sum(AD),Sum(AE),Sum(AF) where J contains 'CUS' and (...

This may be a basic question, but I could not figure it out even after spending a while on it and the documentation. How do I add new elements/nodes to a mindmap/horizontal tree? The blue arrow ...

I have a construction business and a team of contractors. We are constantly having an issue where the contractors are unsure of what project reference number to assign their projects so as to maintain ...

When I try to sync my meetup calendar to google calendar I get this message: Sorry This email address isn't associated with an active Google Calendar account: https://www.meetup.com/events/ical/...

the phone number for verification that i have is not active and i wrote wrong my secondary mail.. instead gmail.com i wrote gmail.con so I cant get code by phone I and I cant get it by mail eather ?

I'm a photographer. I have a FB page and and IG page and I'd like to schedule posts to post in both places. FB now allows me to schedule posts, and hypothetically also crosspost these posts to IG. ...

I'm using Google sheets to try to generate a Pass/Fail in a cell based on two different parameters; If (R2) is less than 85% AND (I2) equals "T1","T2, or "T3" I need a fail generated. similarly, for ...

I've got a Google Sheets spreadsheet with records of individuals along with a column for comma-delimited phone numbers for each individual. I have been pulling my hair out trying to generate a two-...

Is there any way instead of counting them individual in Google Voice ? I had been using hangout to make calls and call history is found in Google Voice but I need to count individually to decide ...

How can I get a subrange of second to last element in a formula under Google Sheets? I'm trying to extract all occurences of "https://example.com/*" in a cell which may contain multiple URLs ...

I am using queries, in order to create a dashboard, =query('Usuarios icorp'!I2:M522; "count(F) when F contains '"&B3&"' ", -1) I am having issues with my query function. I want to count how ...

In my example i have a column with Names of signs we product in our sighshop and I need to be able to isolate similar named signs So say I need to return a a value if the cell is Bud Light and only ...

I'm asking webapps because meta seems to think that it was the right place. Please, see this question and post a different answer if you believe it is not the case. I like my emails to be written in ...

I've got two Google Spreadsheets. Spreadsheet B fetches data from Spreadsheet A using IMPORTRANGE: =IMPORTRANGE("url", "tab!A1:JB19") What I want to achieve is to be able to write over fetched data ...

Does anyone know how to use conditional formatting on Excel Online? More specifically, I am looking into how you can highlight a whole row once a cell has something inputted into it. That way I know ...

Let's say I have CVs (saved as CSV, a database or any other data source) of many people. How can I generate a CV as a PDF file for each person individually that follows a general template, but ...

I have spreadsheet that looks like this: Now when I filter on a company I want the total to display the sum of the whole of B column. Since I am very new to spreadsheets I was hoping someone could ...

I need to either BCC or forward all outgoing mail from a G Suite account to another account on the same domain. There used to be a setting to route email per account, but it seems to have disappeared....

How to find out how many importranges are being used in a single Google Sheet?

I am having a Google Doc with good quality images. Later once my document is completed I have downloaded the web-page (HTML, zipped) version. When I saw the images in the folder they are of poor ...

I frequently use the Google Photos application on my Android phone, where I make use of the Google Lens feature there. Right now I'm managing my photos from the Google Photos web application in ...

Let's say I have a range called WidgetTypes in cells C5:M5. I want my formula in cell A1 to return C5:M5 or $C$5:$M$5. What formula goes into cell A1? cell("address",WidgetTypes) returns $C$5 but I'...

I am migrating from G Suite to Personal Gmail via POP3 and am getting tons of these messages. "The message "Subject" from Someone (someone@somewhere) contained a virus or suspicious attachment. ...

I have a list of words in Japanese. I want to write a formula that will input the word, e.g. ひらがな, and output it as an array of however many characters: ひ + ら + が + な, no matter the length of the word....

Corrected version of my translation doesn't seem to appear on the video, there is still the old version and I can't even edit it now because it's locked. How am I supposed to fix this?

I am trying to filter one column A-Z to pair items listed in more than one selling app. However, if I apply an A-Z filter for a column with item codes, the sheet rearranges everything per the filter ...

Payroll Management System DataBase Design, let me know if i made a mistake for my normalization so that i can denormalize if it's good please give me some like.

As manual here You can create lists to organize your friends on Facebook (example: Close Friends, Acquaintances) and see posts from a specific friend list all in one feed. I created a list with 5 ...

I get so many shopping emails, travel emails, etc. I want all my emails, except what I deem important, to go into a different mailbox so I don't see all of these on my iPhone. How do I do this?

I would like to use this code : function onEdit(e) { if(e.range.rowStart === 1 && e.range.columnStart === 1) { e.range.offset(0,1).clearContent(); } } but only on a tab called '...

I want to have auto numbering dependent on cell drop down box in helper column so i can sorted out. If someone pick Start in A2 to have number 1 in B2. Then if they skip one or two and chose Start ...

I am trying to calculate the total money that can be made from dollar cost averaging every year using Google Sheets. For example: how would I evaluate this?

Here's my test sheet: Localization is USA with timezone GMT+1 I've tried substituting ',' with ';' to no avail. https://docs.google.com/spreadsheets/d/1pZku_X6b49uMhKivnv3N1uv6sekYrhY12IlUct_Zudc/...

Following hibernate multi-tenancy database approach https://dzone.com/articles/spring-boot-hibernate-multitenancy-implementation, I am developing a multitenant application in which around 500 users ...

I usually don't want to buy stuff on amazon if I can't return it for free. For some sellers, you have to pay the shipping cost when you return the stuff. While searching for products, can I filter ...

I've had some bad experiences with international sellers on Amazon. They fall into two categories: Shipping time: It took ages until the product arrived (sometimes more than 6 weeks; mostly sellers ...

I am super new to anything coding and google sheets. All of what I've done was was trying to follow the directions of another question I saw on this site. However, as expected, nothing is working! ...

I have a worksheet with 13 sheets. the largest one has 2000 rows. I have already deleted all the possible blank rows i could. I have also read all the guides on how to make a Google Sheet faster and ...

I was curious to see if there was any way I could see all of my YouTube comments, and there is, in the history section. I have a lot of comments, and after scrolling through them for a while, I wanted ...

In programming, I could use a switch/case statement to do something like this: func animalNameFromType(animalType: Int) { switch animalType { case 1: return "dog" case 2: return "cat" ...

I am trying to add an Auto reply to emails received during non-business hours. The vacation responder does not allow for this. Business Hours are Monday-Thursday 8:30 am-4:00 pm and Friday 8:30 am-12:...

I have a document where I use one sheet for presentation purposes. It's like a window/viewer of the content of the main sheet (the cell contents are all references to the main sheet). I built myself ...

In Gmail, if I snooze an email until some particular date and time (e.g. 1pm), then I physically go to another time zone and remain there, when does the notification occur? At 1pm in the new local ...

I have tried to access my account without any success. I forgot my password and have tried several times. A verification code is sent to me yahoo account and all goes well but I get a message that ...

I have an image in a folder that I want to import into my spreadsheet (in a cell). I'm using the script from Insert image from Google Drive into Google Sheets (with some modifications). But this ...

Instead of editing replies Slasdot.org shows users a preview. Supposedly this allows you to spot any mistakes and correct them before posting. However this doesn't work for me at all. Usually I want ...

I'm currently using VPS to host my web app which price is fixed per month. I read about cloud services such as Google Cloud Platform and their pricing is based on resources usage. My question is how ...

I pasted a table into Google Sheets (part of Google Docs), and one column is 1/234 1/102 1/1222 1/83 and when sorted according to this column, the column data is treated as "text" and sorted ...

when I import a range, in Google Sheets, or I use the formula Filter(), I get an array of data. I would want to then be able to edit the imported/filtered data, is that doable? of course, without ...

Is it possible to pass a URL to a google sheet and have the sheet append a new cell with content taken from a parameter in the URL?? Use case: In KDE (and other environment as well, perhaps), most ...