Save as PDF with File name Hi All, I want to save to PDF with reference to a value in a cell Sheet SalesInvoice, Col H8 has the…

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

How do I show a blank cell if a calculated number is less than 0? How do I show a blank cell if a calculated number is less than 0?

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

Shortcut for expanding / collapsing Gsheet groups ? Is there a shortcut for expanding / collapsing Gsheet groups ? I only found one to create / delete g…

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

FILTER function not working with ISDATE criteria I am attempting to use FILTER in a manner similar to an example in the Help Center: FILTER(A2:A10, N…

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

I am trying to access a google excel document created by a former employee I am trying to access a google document excel sheet, i am able to view it but unable to edit it - th…

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

Combine 2 google survey results into 1 form I would like to combine 2 identical surveys that were sent to different people into 1 page result

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Trying to use IFERROR to hide #DIV/0! Hi, I'm trying to make sheets show an empty column instead of #DIV/0! error, but instead I'm getting…

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

Multiply and add quantities by numbers in another column Hi! I'm working on a meal planner and grocery list generator and I'm having trouble combining some f…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Calculating Time Interval - format issue I'm trying to calculate time intervals. I have a sample sheet here: https://docs.google.com/spreadsh…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

Hide the row numbers Is it possible hide the row numbers (the first column in Gsheets)? I am nor asking for hiding rows A…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Query Function trouble with Time/shift selection Hi, I currently have some query functions picking out times depending on when they are free. ​​=QUER…

0 Updates 0 Recommended Answers 3 Replies 0 Upvotes

Sheets Array Formula Hi , I need help with my arrayformula. So in my Google Form I have Store, Check In & Check Out. So i…

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes

Sum of transactions on certain days of the week Hello everyone! I am trying to create some kind of formula or chart that will display £ taken on spe…

0 Updates 0 Recommended Answers 5 Replies 0 Upvotes

Cant add more decimal places to the percentages of my pie chart. Please help omg this is so frustrating. I just want to know how do I edit the percentage of my pie c…

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

Fill cells with values based on value chosen in another cell I'm not particularly good with Google functions and would really appreciate some help with these thi…

0 Updates 1 Recommended Answer 4 Replies 0 Upvotes

I have two lists I am trying to reconcile and return unmatched values I am trying to find matches from column B on the office log column F. If there is a match, I would t…

0 Updates 1 Recommended Answer 6 Replies 0 Upvotes

GOOGLEFINANCE Function is not inporting the REIT stock price of the TASI MARKET I am using google sheet to track my stocks and dividends, and i am using the GOOGLEFINANCE function …

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Editors able to edit protected ranges using scripts on google sheets I have editor access to a spreadsheet and cannot access some cells due to protected ranges. However,…

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

Return data list based on cell contents Hi, I am currently trying to build a make-shift database in sheets for service users for a charity t…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

If with AND and vlookup Hi All, Struggling with this one Sheet SalesInvoice from order, BQ I need to match 2 values, make su…

0 Updates 1 Recommended Answer 3 Replies 0 Upvotes