Skip to content
  • Try Smartsheet

    • Add Ons and Integrations

    Add Ons and Integrations

    Ask questions about Control Center, Dynamic View, DataMesh, Pivot App, Calendar App, or WorkApps. Discuss connecting Smartsheet to your other systems with integrations such as Bridge, Data Shuttle, the Jira connector, and the Salesforce connector.

    Pivot App Zero Values

    Community Champion
    edited 06/14/22 in Add Ons and Integrations

    Hi All,

     

    I'm using Pivot App to summarize the number of records from a variety of reports. It works great, but if there are no records in a report, the pivot table will report blank. I was hoping for a "0" value, as I'm pushing the data in these fields as number summary in the Dashboards/Portals.

    Other than creating new columns with IF statements, or separate sheets with countif cross-sheet formulas, is there a solution I can apply to the Pivot App?

    Zero_Pivot.JPG

    Tags:
    · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Answers

    • Employee

      Hello, 

      Currently Pivot doesn't have a way to send a 0 when it doesn't see any values that match, but I'll be sure to let our developers know that you'd like to see this sort of functionality. 

      The two workarounds you mentioned would be the best way to get the counts you are looking for. 

      -Zack

      · Share on FacebookShare on Twitter
    • ✭✭✭
      edited 08/26/19

      Zack - Its been over a year, are there any fixes in the works on this?

       

      Showing a blank cell vs. a 0 is confusing to a lot of Stakeholders. Their initial belief is to think the Pivot table is broken. 

      · Share on FacebookShare on Twitter
    • ✭✭

      Same question as posted Aug of last year. Very annoying with gaps for blank data where there should be a data point of "0" leaving gaps in my trend lines...


      Any fixes on the horizon?

      · Share on FacebookShare on Twitter
    • ✭✭✭

      There should also be the option to provide an empty column (null values) with all zeros if a drop down list values has NOT been used at all. For example, in status field with values: Not started, in progress, blocked, on hold, done. When I start the project, everything has a status of "Not started". I still want to see the other values in the pivot output.

      · Share on FacebookShare on Twitter
    • Employee

      There is still a need for this functionality, just FYI.

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending Posts

    Help shape the future of Smartsheet.
    Share your ideas and feature requests.

     Watch video