I have a report that will generally only have about 15 rows on it.
I see in other threads that Smartsheet will automatically create enough blank rows to reach 50, or at least 10 blank rows always at the bottom. Even if I delete the blank rows from the Sheet (which has hundreds of data rows), they reappear the next time I open either the Sheet or the associated Report.
I've tried filtering the Report to only display rows that are not blank, but it seems to ignore that filter.
The problem is that this report is embedded in Teams/Sharepoint website, and the extra blank rows force the box on the website to enlarge to accommodate them, which makes the widget just look horrible, with only 15 rows at the top, and another 40 blank rows taking up valuable screen space below it, before you get to the next widget.
Is there really no way to not display the blank rows in the Report?