Return cell value based on name and date Hi, I've created a basic production schedule sheet which calculates the percentage of a 8 hour shift…

0 Updates 0 Recommended Answers 6 Replies 0 Upvotes

Formula to highlight cell when data in row correspond to data in column. Thanks in advance can't get a right formula to highlight cells https://docs.google.com/spreadsheets/d/1EM6eRfbpSDWKeC4…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Rounding Issue I'm trying to round an equation to the second decimal, but it won't work. The original equation is: …

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

Is there a way to show a blank cell instead of the #Div/0! ? So I have a whole sheet with answers being pulled into different tabs for different Google Forms. I …

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

Help with an if statement in google sheets I am using this formula currently that works =VLOOKUP(F2,'Sponsor levels'!A$1:B$10,2,false) So based…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

help with Coding issue, I' getting my script to run start and complete, but it isn't doing anything So, I have had some help with this before and I have tried to resort to the previous solution, but i…

0 Updates 0 Recommended Answers 9 Replies 0 Upvotes

How do I get Gemini AI features I watched the Google I/O presentation and was intriqued by the "Summarize this email" feature availa…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Shortcuts in Google sheets not working properly When I try to use some shortcuts in Google Sheets, I run into an issue with any shortcut that uses A…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Creating Exception to Conditional Formatting I'm tracking purchase orders. I've got the formatting to turn the ship date green when it's within 1…

0 Updates 1 Recommended Answer 1 Reply 0 Upvotes

Apps Script command sheet.deleteRow(row) not deleting empty row after moving to new tab I'm using Apps Script w/ the following code to move rows from one tab to another in Sheets triggered…

0 Updates 0 Recommended Answers 2 Replies 0 Upvotes

able to edit my sheet or switch to another sheet and have it show changed on different computer I have a system set up for people to scan into a google sheet for attendance at a seminar. There are…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

Odd hyperlink issue Not sure how I can explain this but today out of the blue my hyperlinks for navigating to "yesterday…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes

QUERY FORMULA ISSUE Hello guys, since i'm stuck more than 8 hours in youtube and google sheet, i try to look up into thi…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Formula automatically apply to new rows? Hey all, I am trying to make it so the formula in columns F, G, and M applies to new rows that are a…

0 Updates 0 Recommended Answers 4 Replies 0 Upvotes

Countif function with dropdowns. I like to use drop downs and I want the counter function to count the names of the selected dropdown…

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Deletion of sheet Few of my important google sheets have gotten deleted on its own on all devices and they aren't in t…

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

How to get back the "Filter only for me" option in google sheet I want to get back the option of "Filter only for me" in google sheet, I accidentally clicked on "ne…

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

Insert date when entry in a line is made Please help. I would like a formula that does the following: Inserts the date in a cell on the line …

0 Updates 0 Recommended Answers 1 Reply 0 Upvotes

Insert table option not available I want to create tables in my spreadsheet but there seems to be only the option to create pivot tabl…

0 Updates 1 Recommended Answer 2 Replies 0 Upvotes

I need a script for app scripts to clear a whole spreadsheet I am making a menu for spreadsheets and can't seem to figure out how to clear the whole spreadsheet,…

0 Updates 0 Recommended Answers 0 Replies 0 Upvotes