Include Sheet Summary fields in Row Reports

Harvey E

I've seen several queries about this, and workarounds but can't find a suggestion so here's one!

I have multiple sheets with the same name (in different workspaces). I want to use a Row Report but separate out / summarise the entries per sheet. The only field I can use is "sheet name" which is the same for all, but what I want to use is a field in the sheet summary (in my case "project name"). Appreciate there is a workaround of setting up a helper column etc but it would be that much slicker if Row reports could 'see' the sheet summary data for many different use cases.