Count rows since last cell contained a specific word Greetings, I've tried many different formulations and have not figured this one out. Sample sheet: h…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Conditional formatting in pivot table Hi there, I am building a resourcing tool that shows 8 x 2 week sprints and need to add some conditi…

0 Updates 0 Recommended Answers 9 Replies 0 Upvotes

google finance no data for tickers TSE:HXT TSE:HXS No data for tickers after company renamed stock symbol TSE:HXT TSE:HXT

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

GOOGLEFINANCE formula not working for certain stock update GOOGLEFINANCE formula not working in Google Sheet for automatic stock update. E.g Bhagiradha Chemica…

0 Updates 1 Recommended Answer 13 Replies 3 Upvotes

Need help to resolve Error In ARRAY_LITERAL, an Array Literal was missing values for one or more row This master file is combination of 23 files and they are still blank document. I just trying to make…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

Sparkline bar coloring the whole cell height/thickness or not Hello ! I recently created a table including a sparkline bar chart to visualise number or participat…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Add number of rows based on cell value I'm trying to automatically insert a number of rows below based on the cell values in a column. So i…

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

A lot of hyperlinks to copy at once I'm trying to copy and paste a lot of hyperlinks at once, but they don't include the hyperlinks. I'm…

0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes

Cells Populated from Dropdown Choice Hi everyone. I have a sku sheet that we use for internal use to track our suppliers item #'s, pricin…

0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes

too many rows I have tried whatever I can, but nothing works. Groups are too slow as you need to add each individu…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Google Form Input Converted Into New Format With Array Formula Help Hello! I have been learning the ways of Google Sheets, but this problem here is still too advanced f…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Consolidating multiple rows into a single row per unique barcode I have barcode scan data coming into this Google Sheet via ImportData(). I am needing a way to conso…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

How to create a dependent dropdown I am trying to create three drop downs, the first dictating what the other two list. I need these dr…

0 Updates 0 Recommended Answers 1 Relevant Answer 7 Replies 0 Upvotes

sheets to contacts how do i export a sheets table of contact info into google contacts?

0 Updates 1 Recommended Answer 1 Reply 0 Upvotes

Counta not recognizing data in previously reliable formula Hello all, I have been effectively using a Counta formula that I received from another post on this …

0 Updates 1 Recommended Answer 13 Replies 0 Upvotes

Insert a "Drawing" into a Chart within Google Sheets All - I have created a line graph and I would like to enter a drawing with text onto the graph. More…

0 Updates 1 Recommended Answer 2 Replies 0 Upvotes

Copy data from one spreadsheet to another with a script/image as a button We copy a project template file every time we start a new project. The first sheet in that file has …

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

How to allow user input to direct the number of data points to include on the x axis of a chart I have a chart of data that changes based on user input and then a chart to display that data. The d…

0 Updates 0 Recommended Answers 1 Relevant Answer 4 Replies 0 Upvotes

Bug Report: GOOGLEFINANCE API - No data returned for HXT (Toronto Stock Exchange) Dear Google Finance Support, I am reporting a bug I recently encountered while using the GOOGLEFINAN…

0 Updates 0 Recommended Answers 0 Replies 1 Upvote

Need to Add Data in Array and How to solve Overwrite Thanks to the help from one of the experts here in sheets, Gill, I have some wonderful sheets workin…

0 Updates 3 Recommended Answers 8 Replies 0 Upvotes