Pivot Table's 'Show Total' shows a incorrect number in a calculated field My sheet is working pretty well, im currently working with the 'Sort by Date' sheet. The issue im ha…

0 Recommended Answers 2 Replies 0 Upvotes

Problem converting to ARRAYFORMULA This seems like it should be so simple, but is turning into something very difficult I can't figure …

0 Recommended Answers 1 Reply 0 Upvotes

Use Left Vlookup with Importrange and iferror Here's my formula: =IFERROR(VLOOKUP($B8,{IMPORTRANGE("1Q4K_z5vuYLqBNqM5iL8ccbFnhVSBG9FIXkdAgvJMqVU",…

0 Recommended Answers 1 Reply 0 Upvotes

Importing data from another workbook, keeping the formatting I'm trying to import data from a single source into multiple workbooks and want to keep the formatti…

0 Recommended Answers 1 Reply 0 Upvotes

How to put in a price list in google form, respondent select against check grids for quantities Am trying to prepare a price list of various items which potential customer might need. Have opted f…

0 Recommended Answers 1 Reply 0 Upvotes

Our form says no longer accepting responses due to me being out of storage (Which I am not). My form says it is no longer accepting responses due to lack of storage but we have over 14 GB free …

0 Recommended Answers 8 Replies 0 Upvotes

Counting unique values across multiple sheets based on one or more criterias Hello, I am trying to count unique beneficiaries assigned to each case worker. I have tried using a …

3 Recommended Answers 22 Replies 2 Upvotes

How to change default font color in google documents? I have a schedule for 4 people set up in google documents. Each person can access it to make additio…

0 Recommended Answers 1 Reply 0 Upvotes

How to write app script which automatically sends email to the id which has been added in the sheet Hello I have a HTML, CSS form on my website which collects Email id and name respectively. I am taki…

0 Recommended Answers 0 Replies 0 Upvotes

IF formula with multiple conditions We are creating Language Placement Tests in Google Forms for our business and we had assistance with…

1 Recommended Answer 2 Replies 1 Upvote

How to fetch a single row using sheet API(v4) with some condition (select * from where C=true) I need to use the spreadsheet as my database. So I want to query it instead of looping all values(No…

0 Recommended Answers 5 Replies 0 Upvotes

Display all data from 1 sheet to another from referencing Team A from source "Assigned Team" column I'd like to display all data contained in my source document (Rows B - I) into another Google Sheet …

0 Recommended Answers 1 Reply 0 Upvotes

How can I get the average of a range of ratios formatted as text? Hello, I am trying to average a set of ratios in column E that are formatted as text. The values loo…

0 Recommended Answers 4 Replies 0 Upvotes

Getting the following TypeError: Cannot read property 'getDataRange' of null (line 154, file "Code") I am getting the following error "cannot read property 'getDataRange' of null (line 154, file "Code"…

1 Recommended Answer 2 Replies 0 Upvotes

when trying to select values (if it's a URL), this breaks the formula when trying to select values (if it's a URL) or simply placing the cursor in the field of a formula …

1 Recommended Answer 8 Replies 1 Upvote

Increasing the capacity of Spreadsheet cell from 5M to 5M+ How should I. Increase the capacity of cells from 5M to more is there any way to increase it?

0 Recommended Answers 0 Replies 0 Upvotes

What type of formula need use in google sheets for count values in table? Hello, I don't know what type of formula use for counting change item_IDs (from item_id ... to item_…

5 Replies

How to import data based on dates from one tab to another into a set range I am trying to create an invoice generator and I want to import the data from my "Hours Log" tab to …

1 Recommended Answer 3 Replies 2 Upvotes

apps scrip help-find the first available row in a named range I'm trying to put together a script which will move 4 cell rows between named ranges based on a stat…

4 Recommended Answers 16 Replies 7 Upvotes

Connected Sheets - apps script getDataRange not working for a DATASOURCE sheet Hi, I have been testing new feature in Google Sheets - Connected Sheets. It is a cool function but w…

0 Recommended Answers 0 Replies 0 Upvotes