Roll Up Works REPORT only partially

Eva M
Eva M ✭✭
edited 12/09/19 in Smartsheet Basics

Hello, I know that reports have been an issue, but I think I have a strange problem. My reports are not refreshing with the latest data, even hours after the Roll Up sheet (on which the reports are based) is updated. When I go to my Roll Up Sheet (on which the report is based), and scroll all the way to the right (as if I wanted to see all the columns), the "save" button suddenly activates on top. When I click it (save), suddenly my Report refreshes. I can't keep going in every day and saving an unchanged sheet, just so that my Reports work. Any work around? I thought of maybe just sending out my Roll Up sheet as a PDF instead of the Report (since the Roll up is identical to the Report). Is that a viable option or am I missing something? Thank you!