Hi, I have an inventory sheet where users are putting products in a box, the user would like to minimize the number of clicks as they are moving large number of products a day but these products will go into several boxes. is there a way to have a form look at a value the user maintained in a table,


I'm attempting to create a formula that will count the number of cells in a column from range in another sheet, that only includes the cells with a checked box.


In other words, there are two columns to include in the count from my Communication Tracker sheet:

Done -- checkbox column




Hi everyone!

Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified" 

Here's the problem: If someone only "views" the sheet & doesn't make any