Permission settings for owner of sheet
I have a sheet that feeds into a report, that report is then linked to a dashboard in Calendar view. When I made the calendar from the sheet, it was showing all the hidden columns which is why I tried publishing a report of that sheet instead.
However there is one thing I cannot modify, even though I am the owner of the sheet, report and dashboard:
(This is from the dashboard view when choosing settings)
What can I do to get the option to do a range of dates rather than just the single date? It lets me set this for the individual sheet, but I do not see the option to modify that on the report.
Edit: nevermind, I did not look hard enough, the report needed to be in calendar view to get the option.
Help Article Resources
Check out the Formula Handbook template!