Are grouping on reports not possible with columns that use an index formula/have cell-linking?

Michaela Collins

I wanted to create a grouped report by "Assigned To", but we use an external team roster sheet and an index formula to index the role and fill in the Assigned To column. My report is saying that the "Assigned To" column is blank, even though it is returning values from the Team Roster Sheet.

Ramzi

Check to make sure the report is showing the value of Assigned To before you do grouping. Then make sure the column name did not change in the sheet.

Michaela Collins

@Ramzi There are values, they show that it they are being linked in (via the blue arrow on the right of the cell) via an index formula. And the Column Name is still "Assigned To".

Ramzi

That's very odd. Try this first - unselect the Assigned To column in the report. Save. Then reselect it and regroup. See if that resolves the issue.