Browse the Google Docs Editors Community
Identifying if column or adjacent cells in row contain specific values I have a Google Sheet where a rater will enter a score of 0, 1, 2, or 3 for different indicators eac… 0 Recommended Answers 1 Reply 0 Upvotes Please help with betting sheet (finding max number in a column etc) Hi all I need some help completing my betting sheet please. Anyone with a link can edit, the link is… 0 Recommended Answers 9 Replies 0 Upvotes Slicer Adding in Grand Totals from Pivot Tables to Charts, Sometimes (But not Wanted) I added a slicer to a group of pivot tables all on one sheet. Each pivot table has its own chart, th… 0 Recommended Answers 2 Replies 0 Upvotes Trying to get the time when other cell is filled. Hello, I am trying to make an attendance sheet, I need to capture who went with the child and who co… 0 Recommended Answers 0 Replies 0 Upvotes Conditional formatting: colour entire row based on 3 date conditions in specific cell The data in my sheet is from A3 to AO1000. Column AG contains dates, from AG3 downwards (AG3, AG4, A… 0 Recommended Answers 1 Reply 0 Upvotes Using importrange syntax on different google sheets Hello. I have a doubt regarding import range. Is it possible to use the importrange syntax on differ… 1 Recommended Answer 5 Replies 0 Upvotes Error (Pivot Table)
Result was not expanded automatically, please insert more rows (38203).
I'm trying to pivot some data, on adding row I got #REF error with description "Error: Result was no… 0 Recommended Answers 0 Replies 0 Upvotes Is the menu bar still unavailable in the tablet/Android version of Sheets? Does anyone have a workaround for this issue? Thanks. 0 Recommended Answers 0 Replies 0 Upvotes Find qty units sold by date , Sumproduct formula Can you help me fix formula in Column B-C to find qty sold in last 7,30 and 60 days. Data Cell A1 = … 0 Recommended Answers 0 Replies 0 Upvotes Need Sheets script for when you add a new row, it will auto populate specific cells with text https://docs.google.com/spreadsheets/d/1UB_OgsOPmLNc8ejuLCkeBvtWGKjjQGQ_9g218EF6x8w/edit?usp=sharing… 2 Recommended Answers 5 Replies 1 Upvote Formula to calculate start/end dates of project steps Hi all, I have a sheet with project info with several project steps showing duration and start/end d… 1 Recommended Answer 5 Replies 0 Upvotes Sheets time stamp Hi guys, I'm trying to create a simple time stamp solution using Google Sheets. The idea: To simply … 0 Recommended Answers 4 Replies 0 Upvotes I need to add our content from one column when two other columns match. I have tried =FILTER(HartfordCodes!C2:D, HartfordCodes!B2:B = A2:A) and I imagine that the Filter fu… 0 Recommended Answers 2 Replies 0 Upvotes Help replacing speechmarks in a cell Hello, I'm trying to work out how to replace some speech marks in a cell. The original text is: %5B"… 0 Recommended Answers 2 Replies 0 Upvotes Copy and paste data from google sheets that contains emails I copied and pasted hundreds of rowed of data, containing emails, from one google sheets to another.… 0 Recommended Answers 0 Replies 0 Upvotes Find specific range across multiple sheets and compile into one sheet I've made a list of different movies that I've watched by year along with ratings (out of 10) by mov… 0 Recommended Answers 1 Reply 0 Upvotes How to? Searchable database that shows iframe and url embeds in results? Trying to make a data base of sheet music that can be searched for by level of difficulty, instrumen… 0 Recommended Answers 1 Reply 0 Upvotes I'm trying to run a script which was wrote by Hyde to moveRowsFromSpreadsheetToSpreadsheet_ I'm trying to run a script wrote by Hyde to move rows from spreadsheet to spreadsheet based on chang… 0 Recommended Answers 10 Replies 0 Upvotes How to Reference Cells from OTHER Google Spreadsheet? I have a Dashboard, with formulas that pull data from sheet "OrdersX" (same doc), I'd like to pull d… 0 Recommended Answers 5 Replies 0 Upvotes I am unable to upload excel sheets to the drive....please help I am unable to upload excel sheets to the drive....please help 0 Recommended Answers 1 Reply 0 Upvotes