Having calendar view pull from today's date
Created a report to reflect the calendar view of a sheet and the oldest date is being shown instead of today's date. How can I make the today date be the default?
I added the following formula into the sheet but isn't working: =DATE(YEAR(TODAY()), MONTH(TODAY()), 1)
Answers
-
Unfortunately Gantt view is the only one that has the option to "Open to Today's Date".
Feel free to browse the product enhancement request area to see if someone else has submitted the idea to include this option in Calendar view. If they have, you can vote on it. If they have not, you can submit the idea yourself which will allow others to vote on it. You can also provide the link to the request here on this thread so anyone else looking for the same thing can quickly vote on it as well.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!