Permission settings for owner of sheet

Desertbird ✭✭
edited 01/26/23 in Formulas and Functions


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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!