Hiding NaN from Reports

RyanFMurphy

I have a Report set up and I have it pulling in a helper columns where data isn't filled out until the row is "completed" via other columns in the sheet.

I'm struggling to figure out how to hide the NaN values that show up in the Report because there's no data. See screenshot below.

Ideally, I'd prefer to just have it be blank since there's no data. I can't seem to figure out how to do this.

Paul Newcome

Do you have a formula populating "NaN"? I've not seen a report populate that before.

RyanFMurphy

https://community.smartsheet.com/discussion/comment/349977#Comment_349977

There's a formula populating that column in the source sheets which counts the number of NETWORKDAYS between two date columns to provide a value. We set the formula to be blank if there is an error in order to just show as blank as follows:

=IF(NOT([Project Type]@row = "No Review"), IFERROR((NETWORKDAYS([LSP Delivery Date]@row, [Actual Delivery Date]@row) - 1), ""))

The rows that have been marked as Delivered will have those values automatically filled out but the rows that are still in progress (aka Linguistic Review) have one (or both) of the date columns empty.

Paul Newcome

have you tried including a range/criteria set in your report filter to not show rows where that value is blank?

RyanFMurphy

It's a great suggestion, but we want to show ALL rows regardless of whether their Status column is showing as completed, in progress, or not started yet.

EEK

@RyanFMurphy was there a resolution for this? I'm having the same issue

RyanFMurphy

Nope.