Need report that only shows fields that are NOT blank

josh-a

Hi, new to Smartsheet but enjoying it so far. I'm building a report from multiple sheets that would ideally be a master list of all the rows that do not have a blank cell for one specific text/number column. The values within the column will vary widely but some will be blank, and I do not want to show the rows that are blank.

In the report builder there is an option to choose under the "What" the column "is blank", but no option to choose "is not blank."

Is there any way to do this? A quick few Googles and a little searching around this site hasn't brought up anything helpful.

Thanks!

Andrée Starå

Hi Josh,

Welcome to the community!

Yes, there is! You'll use the Exclude selected items checkbox (see picture)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Bryan Long

how can you do this now with the way reports are setup now @Andrée Starå