I have a list of transactions in Transactions tab and in Summary I would like to summarize by tickers the performance. I am using query for grouping the data an
I'd like to know if there is a formula or a way in google sheets that : 1/ for each value "sku" and "princing" I have a dedicated set of "rows" that replicate t
Having a bit of trouble using importJSON for the first time in Google Sheets. My data is importing as truncated and I can't find any way to really filter things
Im having trouble importing data from my another sheet. Its quite big, has over 500 rows and to 100 columns. (I dont know if thats important but it has about 50
I use this formula to get dividend: =IfError(IF(isblank(A2),"", substitute(index(IMPORTHTML("http://finviz.com/quote.ashx?t="&A2,"table", 8),7,2),"*","")),0
I have an authorization problem, but I can't figure it out. I have 50+ spreadsheets each for a separate user in our company. Each user spreadsheet has a contain
I'm trying to get the sum of all items in column F:F when Column J:J = "Channel"and Column K:K = "Country" =DSUM(Sheet1!$A$1:$K$142,Sheet1!$F$2:$F$142,{{Sheet1
With this code I could put the events from google spreadsheet to google calendar, but now I would to sync these events between the two platforms by a unique ID
So I am having some issues with extracting the correct data to the "Battery Logs" Sheet from "FC" Sheet. I am trying to copy the data from the column range C2:D
I want to integrate google sheet with Laravel 8 without any third party tool or connector. I know its simple for many but i am not able to get through. Highly a
I want to integrate google sheet with Laravel 8 without any third party tool or connector. I know its simple for many but i am not able to get through. Highly a
I want to import the TOP LOOSERS table from this page to a Google Spreadsheet but I have no idea whatsoever how to do it.
I have created three google sheets wherein one google sheet is designed as the Masterfile for the data present on the two other google sheets. I was able to mer
With this code I can send the events directly to google calendar from google sheets. The start date and end date are on two different columns
Currently I can connect using gspread and create/share a spreadsheet. I can also read data from said spreadsheet but I have to request it by name. Is there a wa
Currently I can connect using gspread and create/share a spreadsheet. I can also read data from said spreadsheet but I have to request it by name. Is there a wa
I'm in the process of learning the Google Sheets API with Python. I'm trying to extract data from a column in the spreadsheet, but it extracts it as a list of l
I have used importhtml function for google sheets many times and successfully but sometimes I have had no luck in getting it to work. I am doi
My understanding from the docs is that Session.getTemporaryActiveUserKey() changes for a user every 30 days. In my past experience using it, this was true but o
How to check if a cell in google sheet contains $ (USD dollar) currency or Rs. (Pakistani Rupees) currency to calculate two different currencies total?