Problem with Group By Sheet Name - shows old sheet name
Hello Community members,
I want to present team members from several sheets in a single portfolio level dashboard, to show who is a member of what project. The data exists in similarly formatted sheets, one per project, across several projects.
I have a report in which I am grouping by their sheet names. I decided to rename the sheets in order to better clarify what each group meant, since "RACI" is not a term management would be familiar with right now. I replaced "RACI" in the sheet names with "Project Team". Unfortunately, the sheet name appearing in the group by field is still showing the sheet's old name, despite appearing correctly in the Sheet Name field.
I attempted reconfiguring, and even creating a new report from scratch. The screenshot included is of the new report, which itself also shows the old sheet name.
Any assistance would be appreciated. This is a management deliverable and I need to act quickly, so I may end up creating several brand new sheets as a workaround in the meantime.
Thanks - Josh