With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
The timestamps are taken from a Google Form, rest of the data redacted for privacy.
I would like to count the number of entries i have in the current month, using 'TODAY()' so the sheet stays updated as the months pass and more form entries are submitted. I would also like updated totals of the three months and six months including the current month. I have reworked a formula(I do not understand this formula at all )taken from elsewhere on this forum but it fails when the date range spills over to the previous year. On the 'Totals' tab, I have my best guess in column B and the expected Values in D. You can see that December returns zero. I am open to alternative methods, especially if they are simpler/more readable.
Please let me know if there is more information I can provide. Thanks in advance.
How to get sheets to pick a value from a table that is closest to a target value in Sheets
I have a table that contains testing data values for speed and torque of a motor. I am doing a calculation to give me a calculated speed. I want to make a formula that will find the speed closest to my target value, and then grab the torque that is associated with that speed. The goal is to find the actual attainable torque based on a theoretical speed.
Target speed 1000 RPM
table in separate sheet
I would want the cell to display 19 as the answer given the input of 1000.
So its looking up a value closest to the target value and then grabbing the number from the cell beside it. Hope this makes sense
I have a schedule for employees. But when we sort the sheet it puts everything by a to z the I would like it to actually put the response in the right order starting Monday morning. The problem is Friday is always first. but more importantly, 1 am is followed but 1 pm.
I'm wondering if it is possible to create custom conditional formatting of a cell based on its absolute value difference from another cell. In the spreadsheet linked below, for example, I would like to have B13 and B14 change color to indicate their difference between each other is greater than 1.
For context: these are essay scores that have been assessed twice by readers, so each "Essay ID" corresponds to the pair of scores each essay has received. I'm hoping to create custom conditional formatting that would highlight where reader scores vary by more than 1 for each column B through H. Is this possible?