Rows in Reports Not Pulling Sequentially from Project Plan

edited 12/09/19 in Smartsheet Basics

I have a project plan in which the order of rows appears as per the first screenshot. However, when I pull these rows into a dashboard, the order changes (to the second screenshot). The report must have the rows in the same order as they appear in the project plan, as they are sequential. Does anyone know the solution to this issue? These reports are pulled into dashboards for executive reporting and this is causing a major issue. Thank you!



Screen Shot 2018-10-12 at 7.52.20 AM.png

Screen Shot 2018-10-12 at 7.58.04 AM.png