google-spreadsheet

You need to filter the data using query in googlesheets. Does not sum cells with a value with empty values. Does anyone kno ... C) = month(date '2010-02-01') AND year(C) = year(date '2020-02-01')) group by B label sum(I)+sum(J)+sum(K)''"; 0 )

There are 2 tables in google spread sheets (different files). When using the formula SUMIFS (and SUMIF), the formula IMPORTRA ... data using IMPORTRANGE (cell B2). If I try on IMPORTRANGE without SUMIFS, everything works. Why doesn't it work with SUMIFS?

I use Google Sheets to collect statistics on a daily basis. I need to change the background color of the cells in the range A ... version of the table: https://docs.google.com/spreadsheets/d/1rn03GQfde0V6L39epOf9KiBrw9k2uRNNlcsDC7jjh8M/edit#gid=425680271

There is a google table, editing rights are given to everyone. There is a myonEdit script-set to run as a trigger that sends ... necessary to hide it, or I don't even know how. I think there is a way to achieve what I want. Tell me which way to Google.

Tell me if it is possible to replace the formula with a value. Namely, there are two numbers that need to be multiplied (cell ... d it to show like this when selected: So that when copying to another document, I have not saved the result, but two numbers

Actually, the question is in the name of the topic. I tried it like this , but it didn't work: SpreadsheetApp.openById(OrderSpreadSheet); So it opens the file on the server, but how in the browser?

Interested in the question of how to install a sheet when writing data to a Google table using java, by default, sheetid = 0 ... D") .setInsertDataOption("INSERT_ROWS") .setIncludeValuesInResponse(true) .execute(); }

I can't beat Google Tables so that my formula is added to all new rows and the data from the formula is taken from the cells ... in the AG column I scored the formula with my hands, it works correctly In the AH column through the array-it does not work.

Closed. This question should be specified . Answers to it are not accepted at the moment. ... In excel on vba did... here somehow everything is not so... If anyone has a link to Russian-language resources, please write.

Is there any way to get a picture (png/jpg) from part of the Google sheet range as a placemark? I tried to build a diagram in ... var chart = chartTableBuilder.build(); sheet.insertChart(chart); // var img = chart.getAs('image/png'); Здесь ошибка

Question about working in Google Sheets: I want to create a drop-down list in a table that will take data from several column ... d substitute it for the current sheet. See the screenshot for more details. Is it possible to implement this, and if so, how?

How do I implement a drop-down list with values from another table? There are 3 tables: Report; Projects; Tasks. You need to import projects and tasks to them into the report

How to implement data exchange between tables Google Spreadsheet? For clarity, I visualized everything in the picture: The ... ocuments. When you edit the cells, the information should be updated in a different table. String matching must be observed.

There is a table with two sheets in Google Docs. How can I combine their data by a common "Article" field if the values match ... ogle_docs_url"; " List2!A1:D4") but it does not perform a SKU mapping As a result, you need to get the following table

Several people have access to the table, each of them needs specific data, and to make it easier to work, each of them uses f ... table. Consider this. I am waiting for both specific suggestions for setting up or ways to organize the work of the office.

The question is: is it possible to control the updating of data from formulas? (Specifically interested in the formula IMPORT ... le may be updated faster, another slower, and the third is not updated at all it is updated, and you need to press F5 again.

How can I automatically fill in the current date when a value in one of the columns changes, BUT then this value is never fil ... Now I did this: =IF(A69<>"", TODAY(), "") But each time the sorting is applied, the date is reset to today's date.