Issue with report not displaying all rows on Dashboard

Kristin R.
edited 02/09/22 in Smartsheet Basics

I created a report based on a date, which itself is the result of a formula based on a number + an Assigned Date. The report displays a count of each row that has a particular date. The issue is that the dashboard will not display the first row with a count (see screenshots). When I re-sort the data to display the newest date first vs. the oldest (and the newest date moves to the top), the newest date disappears. So it has something to do with that first row.

Has anyone experienced this? My colleague and I cannot find any reason for it, and this is not happening with my other reports - they are all displaying 100% of the data.


  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Kristin R.

    It looks like you might have a setting toggled off in the Chart Widget - check to see if the first setting "Use column names as category labels" is turned on or off.

    If this is toggled off, then the Chart will take the first row as the category labels, which may be why it's not showing up!