Browse the Google Docs Editors Community
Updated: Today
Counta excluding errors How do I count the valid cells in a range that have strings? My range is a formula that returns #N/A…
0 Updates 0 Recommended Answers 1 Reply 0 Upvotes
How to change the way averages are calculated on google gradebook I am using the gradebook template and I want the running total percentage column (D) to display ONLY… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
How to get a Google Sheet App script to skip empty rows? Hi, I am new to using App Script. I have a script from https://gist.github.com/palumbo/d751841c3e617… 0 Updates 1 Recommended Answer 2 Replies 0 Upvotes
Match and Return formulas I'm trying to set up a formula with regexmatch and regexextract to: 1. Determine if a specific text … 0 Updates 0 Recommended Answers 1 Relevant Answer 2 Replies 0 Upvotes
Sheets script - copy only if cells in a range not blank Hi, in the following sheet https://docs.google.com/spreadsheets/d/105sKzlXN8ClX7OzcdSeiNAUrLxURKm4NS… 0 Updates 1 Recommended Answer 2 Replies 0 Upvotes
Requesting help with array formula to extract first and last name and ignore blank rows. Hi, needing some help extract the first, middle, and last name into columns B, C, and D from full na… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Updated: Yesterday
Which One is Faster: Big Formula vs Wide Columns Hi I just wonder which one would be faster for my googlesheet to proceed its data: 1. Giving it a he…
0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Count Colored Cells function automatic update I'm using a =countColoredCells function that counts the amount of cells with a specific color that I… 0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes
Conditional formatting based on another sheet I use a google sheet ("Sheet A") to track maintenance and inspection items on a list of aircraft. I … 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Count Check Marks in Specific Cells? I want to count check marks in specific cells, not an entire range. For example, I want to count jus… 0 Updates 0 Recommended Answers 0 Replies 1 Upvote
How to insert today's date in a cell (I don't want it to change after) I just want to insert simply the date in a cell without typing it. I don't want it to change after 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Seeking method to pull data from cells on one tab into cells on a different tab Hello, I mistakenly included this as a second question on my previous post. Hyde provided a great so… 0 Updates 1 Recommended Answer 4 Replies 0 Upvotes
New rows added to sheet, Need copy Only LastRow to new sheet and edit I have Outlook auto populating emails to my Google Sheet, this works fine. But when a new row is add… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
If Past date and Status hasn't Changed Hi All, Hoping someone has a quick formula for this: If the selected date has passed in cell J24 and… 0 Updates 0 Recommended Answers 3 Replies 0 Upvotes
Comparing two strings for similarity? Hi! THE SHEET I have a Sheets document that has a list of Plants, and each Plant has an English Name… 0 Updates 1 Recommended Answer 3 Replies 0 Upvotes
Google Sheets and Docs Printing Entire Document Problems. In Google Sheets on my Mac only what is shown on my screen is what prints, not the entire document. … 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Complex Regexmatch: match any 3 out of multiple words in a cell I need a formula for Google sheets that looks up wines, and returns if they are a 12 pack or a 6 pac… 0 Updates 3 Recommended Answers 12 Replies 1 Upvote
Needing to change formula references I am doing a formula that is linking cells from one sheet to another. The formula is adding a group … 0 Updates 0 Recommended Answers 1 Reply 0 Upvotes
I'm setting up a budget. How do I get a monthly report? I've got some expenses noted for my first month. My question is, how do I go to the next month? I do… 0 Updates 0 Recommended Answers 8 Replies 0 Upvotes
I cannot write formula to auto-populate current date when operation is completed Thank you very much to the leaders of this community who have this resource and process so well orga… 0 Updates 3 Recommended Answers 7 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