Browse the Google Docs Editors Community
Updated: Today
Can I get the value of a cell (instead of a const) to compare against in WHERE clause of a QUERY? I want a query that will show me all rows which contain a string that is in a particular cell in the…
0 Updates 1 Recommended Answer 7 Replies 0 Upvotes
Nesting INDIRECT in IMPORTRANGE in COUNTIFS Hey y'all, So I have 2 separate documents, DOC1 and DOC2. DOC1 contains multiple tabs, and each of t… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
etf expense ratio formula what is the formula to find expense ratio for etf 0 Updates 0 Recommended Answers 2 Replies 0 Upvotes
organize table to remove blank cell in google sheet I have range A1:D3 and I want it to appear as F1:I3 using 1 array formula. I tried ArrayFormula with… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Array formula I want an array formula in column d to calculate the current price variation from all time high of a… 0 Updates 1 Recommended Answer 3 Replies 0 Upvotes
Background color and text color in a cell turns green Onee cell is turning green I am not clicking on background color. where ever I put the text the cell… 0 Updates 0 Recommended Answers 1 Reply 0 Upvotes
hide filters Hi, I have a "hide filter" (filtro oculto) and don't know how to erase it. I can't see the entire sh… 0 Updates 0 Recommended Answers 1 Relevant Answer 9 Replies 0 Upvotes
Updated: Yesterday
I want google sheets to add up a column that has durations in the format of [XYZ minutes]. I have a column (Column D) that has time durations in the format of [XYZ minutes]. For example, "61 …
0 Updates 1 Recommended Answer 2 Replies 0 Upvotes
Placeholder text in Sheets Hello! 1. I see that if I create a table within Sheets that it creates placeholder text. How do I ed… 0 Updates 1 Recommended Answer 1 Reply 0 Upvotes
Advanced Sales Tax Formula Hello, I am creating a small home business bookkeeping tracker. I have expenses/revenue per month an… 0 Updates 1 Recommended Answer 10 Replies 0 Upvotes
Using REGEXMATCH but where the regular expression is in a column I have a long list of Products. I have a second list of certified product families I am trying to us… 0 Updates 1 Recommended Answer 3 Replies 0 Upvotes
Use of Open-ended References in Protected Ranges Is it possible to use Open-ended References in Protected Ranges? It seems that they are automaticall… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
orders change when I sort You will see from the sheet that it is a list of employees. I did not put any information in i just … 0 Updates 0 Recommended Answers 1 Reply 0 Upvotes
I copied and pasted a wrong number on a Google sheet cell.. How do I recover the number? How 0 Updates 0 Recommended Answers 1 Reply 0 Upvotes
Conditional Notifications Email Will there be an ability to customize the actual notification a bit more? OR can google show the ent… 0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes
Mass edit formulas Hello, I have two sheets I'm duplicating, ~20 times. One sheet provides data to the other sheet. The… 0 Updates 0 Recommended Answers 1 Reply 0 Upvotes
Exporting to pdf a Google sheet containing a formula with google translate prints "loading" When exporting a google sheet to pdf, it shows a "loading..." instead of the result of a formula tha… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Help with a sheets Query I'm planning a reunion and have collected information from my guest which includes tee shirt orders.… 0 Updates 3 Recommended Answers 10 Replies 0 Upvotes
Hyperlink cell not working When I hyperlink a cell and then click the link it does not route to the link 0 Updates 0 Recommended Answers 4 Replies 0 Upvotes
Dividing a SUMIFS by 3 Hello! I am trying to make a totals section for this sheet (I have attached it below). For cell U7 I… 0 Updates 0 Recommended Answers 2 Replies 0 Upvotes
Updated: This week
Updated: This month
Updated: This year
Updated: Earlier
Not what you're looking for? Try posting to the public help community
Post a question