nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

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

Find more posts tagged with

Healthcare

Comments

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!

Sign in to join the conversation!

Quick Links

Trending discussions

How to auto populate cells
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Why Can't I no Longer Able to add Folders, Sheets, or Reports in my "Sheets" folder
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…
Smartsheet - you have a problem with the Discussions New Post options