What I am hoping to do is take the =Now() date that is located on my default sheet and in the Row 1 Column 1 cell and somehow when the sheet is accessed onOpen() have it automatically change the active sheet to the tab that matches the current date.

I am a teacher at a behavior school and I created a digital pointsheet my students are having difficulty navigating. I am hoping that a google script can help me. I have asked around and researched the topic, but have not as of now found something that works. Thanks for your time and insights!

Here is an example sheet of what I would like to have Example Form

I feel like the script on this page should work with some tweaking, however I am having difficulty with formatting the date in a way that coincides with the tabs. Here is the link to the script I have been working with trying to create something that meets my needs. Possible Script

New contributor
Kevin Clough is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

When Apps Script read a date from a cell it pass a JavaScript object but the sheet names are strings. You could use Utilities.formatDate.

Your Answer

Kevin Clough is a new contributor. Be nice, and check out our Code of Conduct.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.