Is there a way to make the auto appearing rows disappear on a grid?
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!
Help Article Resources
Check out the Formula Handbook template!