Report pulling in correct data, but also blank lines

Paulacosentino

I have a report pulled into my Sight.  It's pulling in a number of blank lines along with the correct data.  It causes problems when I want to sort alphabetically because all the blank rows are on the top.  Any ideas?  Thank you for your time.  PC

Mike Wilday

Smartsheet automatically adds blank rows to your sheet. But sometimes those rows gather data (like formulas) that you've added. Try deleting all of the blank rows in your sheet, saving, and then run it again. 

Paulacosentino

Thank you!  Yep, I have lines below the data that include formulas.  I figured that might be the problem. 

 

Mike Wilday

You're welcome!