Change Order of Sheets in Report

Art Schneiderheinze
edited 12/09/19 in Smartsheet Basics

I have two sheets that show data from two different fiscal years:

  • [FY 2019] Course Development Tracker
  • [FY 2020] Course Development Tracker

I added both of these to the Report Builder, but I want the data in [FY 2020] Course Development Tracker to appear above the data in [FY 2019] Course Development Tracker.

I thought they were just added alphabetically, so i renamed them to this, thinking it would alphabetize FY 2020 on top, and display that data in the report first. 

  • [b-FY 2019] Course Development Tracker
  • [a-FY 2020] Course Development Tracker

It does not. It still puts data from FY 2019 on top. 

I even tried renaming them numerically, but still get the same results (see attached screenshot):

  • [2-FY 2019] Course Development Tracker
  • [1-FY 2020] Course Development Tracker

Any thoughts to name the Sheets or add the sheets to the Report Builder to have the current FY 2020 data appear on top?

reportbuilder.jpg

Tags:

Comments