Change Order of Sheets in Report

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?

Find more posts tagged with

Sheets

Reports

Comments

Andrée Starå

Hi,

How are you sorting the information in the report?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Art Schneiderheinze

I'm not sorting it. I have the same columns in both sheets, and I just choose the columns I want to display (and the order to display them).

Art Schneiderheinze

Figured it out indirectly from your help. I added Sheet Name (as a column), hid it, then sorted by sheet. That worked.

Andrée Starå

Excellent!

That was my thought as well!

Happy to help!

Best,

Andrée

Sign in to join the conversation!

Quick Links

Trending discussions

HELP! Move Row Automation
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
Published Sheet - Users Unable to add Attachments
I have a sheet for which I've provided a publish link to many unlicensed users. They use the sheet to attach files to rows. This has been working as expected for multiple years previously, but today, we've discovered it will not allow them to attach files to rows and they're met with the message "This action has been…
Reports - Can non-admins sort?
I have a number of reports which live in a workspace. This workspace has a handful of admins, and about 40 licensed users who have editor access in the workspace. Is it possible for these editors to sort reports? Or do I have to make all of them workspace admins for that functionality to be a thing? Seems a bit much…