Is there a way to make the auto appearing rows disappear on a grid?

Options

I've got a Vlookup 'Search Portal' set up on a grid that I'm viewing through a editable published grid on a Dashboard.

It all works pretty well, except for the rows that appear under 'Portal' area. The working area is 19 rows. It adds on 41 blank rows to the bottom which I don't need.

Is there a way to try and suppress if from adding all these rows? Or possibly to filter them out automatically?

I did try adding a hidden column with a value in for all the rows I wanted, and filtered by this value. This sort of worked, but it still showed 10 rows at the bottom, and this filter seems to turn off by itself after a few refreshes.

Any help would be much appreciated!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!