Need report that only shows fields that are NOT blank

edited 12/09/19 in Formulas and Functions

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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!