Browse the Google Docs Editors Community
Updated: Today
Sheets: If then, if then, if then What would be the formula for: IF B1 is blank, then A1 is left blank and, IF B1 is > Today, then Yes…
0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes
SUMIF/CONCATENATE/INDEX/MATCH from Multiple Sheets Help Hi all, I am looking for some help in troubleshooting what I am looking to accomplish. I have done s… 0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes
Google Sheets finding unsuccessful refresh from connected data sources Hi, I am using a Google Sheets with about 12 data connectors to BigQuery and 100+ pivot/graphs. It c… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Is it possible to do a lookup based on a relative data value? I am working on a personal project that is a dynamic tier list for a videogame. It has a "Home Page"… 0 Updates 0 Recommended Answers 4 Replies 0 Upvotes
Display the maximum in a column while ignoring numbers at the top When I try to use conditional formatting to display the largest number in a column it will still pul… 0 Updates 1 Recommended Answer 4 Replies 0 Upvotes
Give ID with number and sum up every 16 duplicates? Hey there, how to give ID with number and sum up every 16 duplicates? Maybe you'll understand in my … 0 Updates 1 Recommended Answer 2 Replies 0 Upvotes
Query Last 10 Games From One Sheet To Another Hi, I am trying to do this for all 32 NHL teams but I think once I figure out the code for one I can… 0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes
Appscript to check which custom menu is selected In my google sheet I have created a Custom Menu. In side a function, i need to check which menu opti… 0 Updates 0 Recommended Answers 9 Replies 0 Upvotes
How do I create a pie chart from Sheets table combing rows with same label into 1 pie sector? I have a sheets table tracking my expenses, with each expense on a different row. In the category co… 0 Updates 0 Recommended Answers 1 Relevant Answer 4 Replies 0 Upvotes
count if data equals column header and row header Hi, sorry in advance if I'm not clear with the question. You can have a look at the sheet below. If … 0 Updates 1 Recommended Answer 5 Replies 0 Upvotes
TEXT function is no longer picking the correct day of the week I used to use the TEXT function to extract the day of the week as text ('Monday', 'Tuesday'...) from… 0 Updates 0 Recommended Answers 2 Replies 0 Upvotes
Updated: Yesterday
Row() number in dynamic range inside arrayFormula... Here below is my formula, that works as intended when I copy down below for a whole column. =countif…
0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes
Date Duration - Ignoring empty cells + ignoring before due date completion Hi all, Here is my open sheet to edit! I need to begin recording how many days it takes us to comple… 0 Updates 0 Recommended Answers 15 Replies 0 Upvotes
Remove FALSE from ISBLANK + SPLIT formula? I am using a google form to collect exam registrations for students. When students register for mult… 0 Updates 0 Recommended Answers 9 Replies 0 Upvotes
Possible to SYNC Value and Formatting of a cell from one sheet to another? I have my own designed accounting system that's spread across 12 sheets (and a few more). 1 for each… 0 Updates 0 Recommended Answers 0 Replies 0 Upvotes
Complex VLookup using multiple criteria and between two dates I've been doing this the hard way for so long that it's become too confusing to keep up. So, instead… 0 Updates 0 Recommended Answers 1 Relevant Answer 7 Replies 0 Upvotes
Hello. How can I flip a spreadsheet so the last line becomes the first? I have a spreadsheet detailing accidents occurring at our school (date, time, location, event etc). … 0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes
published spreadsheet sometimes displays old information I've created some spreadsheets to share information with teachers. The teachers do not need to chang… 0 Updates 0 Recommended Answers 1 Relevant Answer 3 Replies 0 Upvotes
Script: Autoname sheets from master list and KEEP protected sheet with exceptions I have two scripts that I would like to work as one. I have a protected sheet (with exceptions) that… 0 Updates 0 Recommended Answers 1 Relevant Answer 1 Reply 0 Upvotes
Auto-refresh data source in Google Sheets ​​I'm trying to set a trigger to auto refresh the data source connected to Google Sheets but I am un… 0 Updates 0 Recommended Answers 1 Relevant Answer 2 Replies 0 Upvotes
Updated: This week
Updated: This month
Updated: This year
Updated: Earlier
Not what you're looking for? Try asking the Help Community
Ask now