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
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!