Query and importrange, why in two lines? hi, I have a formula which actually returns right value, but why i get in the cell that I enter the …

0 Updates 1 Recommended Answer 5 Replies 0 Upvotes

Doughnut Chart Budget Duplicates Hello, I am working on creating a budget and have recently been entering expenses. I have 2 rows tha…

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

return different results based on 2 conditions I am trying to return different counts based on 2 conditions, this one will not return the results d…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

FILTER & INSA(MATCH) between date range I have a workbook with three sheets. 'Regular' is items I buy each month, 'COSTS' is a list of the i…

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

some of my cells lose content when I move accross them When I move between cells, some open up by themselves, and when I move to another, the original cell…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Sheet help needed Below I have attached an example sheet. I want data I5 and it should be in according to given G5 and…

0 Updates 1 Recommended Answer 7 Replies 0 Upvotes

Leap year function with sheets Hello everyone can I get some help please, as to where to insert the following addition. This is to …

0 Updates 1 Recommended Answer 7 Replies 0 Upvotes

Creating a graph with specific values Sheet: https://docs.google.com/spreadsheets/d/1KYxPovcQMYAmflBWB0ImotPilyN6JJg53exEnDuEZZM/edit#gid=…

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

Create classes based on form response I have created a form for registration for a group. In my form there is parent name and contact info…

0 Updates 0 Recommended Answers 1 Reply 1 Upvote

Converting and expanding dates Hallo. I want to change the date input method on my google form. The date will either be entered as …

0 Updates 2 Recommended Answers 10 Replies 0 Upvotes

Customize a table view I have this two tables, I want the view to look like sheet two, What should I do? https://docs.googl…

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

How to auto-populate a range of columns with the same input from somewhere within that range too Hi, I'm not very experienced with google sheet formulas. I have 8 columns. One for name and 7 for in…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Gantt Chart, Conditional Formatting and Days of the Week I saw some videos in youtube about gantt chart with dynamic dates and dynamic bar. I thought I would…

0 Updates 2 Recommended Answers 7 Replies 0 Upvotes

Copy data from one Sheet to another in Google App Script and append a row Hello Sir, What do I want to do? I have data in "Query" sheet. When I click on the button, the scrip…

0 Updates 1 Recommended Answer 1 Reply 0 Upvotes

I had a google spreadsheet I've been editing and adding to for 3 years -- and suddenly it is GONE! I did NOT delete it. No idea what happened. Is it possible to find it? Checked the Recycle Bin on my…

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

Vlookup with Match Hi all, Please could you assist? I am using vlookup to find a value from another table but is need t…

0 Updates 1 Recommended Answer 6 Replies 0 Upvotes

Combine info based on ID#s I'm trying to find a formula that will search a column for similar ID#s and combine all information …

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

Is it possible to include Saturdays if the work schedule has Saturdays in the timeline? I am trying to view my project program in the timeline with Saturdays included but i don't know how …

0 Updates 1 Recommended Answer 8 Replies 0 Upvotes

Ability to have values added to another sheet based on data validation response Hello! I would like to know if I can take any of the names that have yes next to them in the guest l…

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

Help needed I have attached a sheet link. In table 4, F25 manually written UT, but I want it automatically with …

0 Updates 1 Recommended Answer 5 Replies 1 Upvote