I posted a question a few weeks ago stating I'm a sort of a newbie at all of this and I am trying to learn. I am trying to write some script for a spreadsheet I
I posted a question a few weeks ago stating I'm a sort of a newbie at all of this and I am trying to learn. I am trying to write some script for a spreadsheet I
I have here a condition/function. I'm not really experienced in Google Sheets. =ADDRESS(MATCH(B32,Diana!B:B,0),1) Now, Diana is another worksheet. The result f
Currently, I want to run my google app script at exact time. I have already do some reading about this problem and I decide to follow the solution in this post
In this sheet I'm working on, I'd like only the applicable data to show on the Teacher1Results tab, not the #N/A for empty output. Secondly, is it possible to m
So I'm super new to Google Sheets - as I mostly use Excel and Smartsheet. I was trying to accomplish this by just recording a macro, so this is VERY messy. I ha
Does anyone know if there is a way to use the Google Sheets API to get the email address of a people chip? It seems like the only values it will give me are the
How do I set the pdf size as A4 in the following script? Also, is it possible to fit the sheet into a single pdf page? function sendSheet() { var message = {
Been building a landing page to start an email list. Decided to use Google Sheets as the backend to store emails & Google Scripts to send the first welcome
Please guide me. For how to fix the script to different attachments. In other parts of script is perfected. I want to solution for attachments. See code here
I have a Google Sheets formula below, which extracts the contents between a multi line string: =REGEXEXTRACT(A2, "(?ms)mystring1(.*)mystring2"
I have a Google Sheet with the following values: 12.4840 -8.1870 -0.9630 -3.3210 3.4550 0.3140 3.3470 -7.1290 If I SUM() these, the expected result
I can't seem to find any documentation on what the timeout is for the =ImportData function for google sheets. I have a url that return in 10 seconds and it wor
I can't seem to find any documentation on what the timeout is for the =ImportData function for google sheets. I have a url that return in 10 seconds and it wor
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