I can open a report in calendar view, but it opens on the first date in the report, and I want the ability to go forward or backward through the calendar. Is it possible to open and show the current month by default?
A Report will automatically open to today's date or month in the Calendar View if you have a task associated with today's date. I would suggest adding in a helper task to one of your sheets which always reflects today's date. This will make sure the Calendar opens to the right month!
To make sure the date is always today's date, you can use a formula to populate "today", like so:
You would want to put this task/row on a sheet you will constantly be opening/saving so that it updates the date frequently. You can review a list of actions which will refresh the TODAY function and formula in this Help Article: TODAY Function
Let me know if this will work for you!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
I have a Smartsheet tracker that has been tied to one report. I recently created a second report that pulls similar information from the same Smartsheet tracker and that is working fine. However, the other report no longer shows any data in it for me or others. I have verified that we have admin access on the original…
we are looking to migrate out of smartsheet and are needing to export all of our sheets out and store them in onedrive. what is the best way to preform this?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.