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.