Seeking Automation Solutions to Display Zero Values in Smartsheet Pivot App

System

This discussion was created from comments split from: Pivot App Zero Values.

TimMelton

HI all.. refreshing this thread.. has anyone found a fix for this via automation? The pivot app is helpful, but its limited in its use. populating zero values would be a good first step. Thanks

Kerry St. Thomas

This is truly a preference: while some prefer 0 values, others prefer blanks - the blanks minimize visual interference… if there are fewer nonzero values, they're more likely to be lost in a field of zeroes.

The workaround is fairly straightforward: If you need zeroes to show instead of blanks, on your pivot output sheet, create column formulas along the lines of =IF(ISBLANK([Pivot Output]@row),0,[Pivot Output]@row), and then surface a report with those formula columns in place of the pivot outputs directly. Alternately, you can also surface data by embedding a report on a dashboard that has on it an explanatory statement that "blank" means there is no data to report.