Google Sheets "drop last date" tool???

19 views
Skip to first unread message

Amy Farris

unread,
Aug 13, 2021, 1:46:09 PMAug 13
to GEG Ohio
This is driving me crazy. I have a Google Sheet used for teachers to sign up for Chromebook carts.  I used to have the Sheet set up to, at the end of the day, move the  day's data to another tab called "log" so that only the current date and dates following it appeared on the active Sheet.  That way, teachers didn't have to scroll through past months to schedule a Chromebook cart later in the year.   

I know there is an add on or extension that will force Sheets to drop past dates and move them to a tab called "Log" - but can anyone recall what it is or point me in the right direction? 

LACIVITA, JASON

unread,
Aug 13, 2021, 1:58:20 PMAug 13
to Amy Farris, GEG Ohio
The one we used was called Lab Scheduler, and was an add on for Sheets, and we can no longer use it, and not available in the store.  

On Fri, Aug 13, 2021 at 1:46 PM Amy Farris <far...@westerville.k12.oh.us> wrote:
This is driving me crazy. I have a Google Sheet used for teachers to sign up for Chromebook carts.  I used to have the Sheet set up to, at the end of the day, move the  day's data to another tab called "log" so that only the current date and dates following it appeared on the active Sheet.  That way, teachers didn't have to scroll through past months to schedule a Chromebook cart later in the year.   

I know there is an add on or extension that will force Sheets to drop past dates and move them to a tab called "Log" - but can anyone recall what it is or point me in the right direction? 

--
You received this message because you are subscribed to the Google Groups "GEG Ohio" group.
To unsubscribe from this group and stop receiving emails from it, send an email to gegohio+u...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/gegohio/a550fe05-40da-4aae-a1a4-07bee79a15bcn%40googlegroups.com.


--
Jason LaCivita
Assistant Principal
Edison Middle School
Classroom Technology Support
Edison Local Schools

Paul Beadles

unread,
Aug 13, 2021, 9:57:55 PMAug 13
to LACIVITA, JASON, Amy Farris, GEG Ohio
We have a shared calendar with appointment slots - amazing simple

LACIVITA, JASON

unread,
Aug 16, 2021, 9:13:03 AMAug 16
to Paul Beadles, Amy Farris, GEG Ohio
If you know how to cancel out the 4 minutes between classes, and create clean time slot that aligns to our school schedule I would love to know how you do it.  

image.png

Paul Beadles

unread,
Aug 16, 2021, 9:23:01 AMAug 16
to LACIVITA, JASON, Amy Farris, GEG Ohio
SO it might be tedious but it would be 9 appts each set like this

Monday, August 168:00 – 8:50am, offered as a single appointment
Weekly on weekdays

image.png

Will give you something like htis

image.png

Does that achieve what your trying to do?

Jason Dunstan

unread,
Aug 16, 2021, 9:35:07 AMAug 16
to GEG Ohio
I sent an invite directly to the three people in this thread. Doing what Paul suggests leads to a convenient appointment sheet for people to request. This is the result of the first three periods as Paul described from the end user perspective, and you could have the link to that wherever. One additional suggestion is that you make a new calendar specifically for this room so it doesn't clutter up someone's calendar.



GW_00001.png

LACIVITA, JASON

unread,
Aug 16, 2021, 10:17:09 AMAug 16
to Jason Dunstan, GEG Ohio
Yes, thank you for your help.  

Farris, Amy

unread,
Aug 16, 2021, 10:50:12 AMAug 16
to Jason Dunstan, JASON LACIVITA, Paul Beadles, GEG Ohio
Thanks, everyone.  Lots of options to follow up on!

On Mon, Aug 16, 2021 at 9:32 AM Jason Dunstan <jdun...@pentacc.org> wrote:
I sent an invite directly to the three people in this thread. Doing what Paul suggests leads to a convenient appointment sheet for people to request. This is the result of the first three periods as Paul described from the end user perspective, and you could have the link to that wherever. One additional suggestion is that you make a new calendar specifically for this room so it doesn't clutter up someone's calendar.



Best,
Jason Dunstan
Technology Integration Specialist
Penta Career Center

Need help? Schedule a time!


CONFIDENTIALITY NOTICE: This message may contain student personally identifiable information that is confidential. Such information is intended only for the use of the individual or entity named above. If you are not the intended recipient, you are hereby notified that any disclosure, copying, printing, distribution, or the taking of any action in reliance on the contents of the information contained herein is strictly prohibited. If you receive this email message in error, please immediately notify me by email, and delete the message from your computer. Thank you.

PLEASE NOTE: This message and any response to it may constitute a public record, and therefore may be available upon request in accordance with Ohio public records law. (ORC 149.43)
>>> Paul Beadles <paul.b...@usd253.net> 8/16/2021 9:22 AM >>>
Reply all
Reply to author
Forward
0 new messages