Report pulling in correct data, but also blank lines
Options
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
Tags:
Comments
-
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.
-
Thank you! Yep, I have lines below the data that include formulas. I figured that might be the problem.
-
You're welcome!
