Unable to parse query string for Function QUERY parameter 2: NO_COLUMN: G
I am using the import-range function to pull data from 5 different workbooks into one master sheet.
is it possible use the find function in google sheets for multiple items?
I’m looking to find over 100 items in my sheet, they all have different ID’s attached to them, I could manually do this but to save time I thought group find + copy function would help. I’m super new to sheets so I’d appreciate any sort of help. Thanks
How to find percent from drop down options in google sheets?
I use a rubric for data collection. I am trying to compile it onto an excel sheet for user-friendly accessibility. I have put the content criteria in separate column drop down menus. I need to calculate the percent for each column, and each drop down item individually. enter image description here
is there a way to create a folder in google drive for each new row in google sheets?
I want to auto create a folder in my google drive for each row under a parent folder to save the photos from my app in google appsheets.
Repeating the same formula across rows and create a sum total
I would like to repeat the same formula across multiple rows and then calculate a total sum. Eg. for each row I would like to sum the number of days and multiply that with a day rate and then calculate the total sum for all rows. Currently, I am manually changing the references for each row, but I was hoping I could create the formula once and then pass an array of the rows instead
Returning the aggregate of the last 3 rows of an occurrence in google sheets
I have a growing table from A:Bl. It grows by rows, not columns. I am try to write a xlookup formula that will search column D and find the last three occurrences of English
create graphs in google sheets based on date with aggregates
I’m sure this is simple enough to do for those familiar with sheets. I have a data set that could have 0 to many entries per day sorted in descending order currently. Like this:
Google Sheets – how to show sheet name in SELECT result of QUERY() function
In this formula I need to show the Sheetname in the first column, either concatenated to Col1 or it could be the first column, like this.
SELECT SheetName,Col1,Col2,Col3,Col4,Col5
Adding row splits data validation Google sheets
In the Test spreadsheet here I created a budget table that has dependent dropdown lists. When you select a category in the Main table, column F, in the Subcategory column (G) another dropdown list appears, based on the Category selection. It works fine and I am happy with it except for when I add a row in the main table, data validation in column G (Subcategory) splits and range reference is not good anymore.
Bringing in only certain data based on start/end date?
I have a formula that someone here assisted me with in order to bring in data from multiple sheets.