when I try to create a category report, it says I have ‘no categories’ even though I have set up categories for my spreadsheet and have auto cat working.
The only thing I can think of is that you may have renamed the Categories sheet? Can you confirm that your sheet is still named Categories?