Permission settings for owner of sheet

Desertbird

Hello,

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.

Genevieve P.

Hi @Desertbird

Thanks for posting your solution! I'm glad you got this resolved 🙂