Reports: Automatically highlight Missing Columns to make them easy to identify & remove/fix

NeilKY

I don't know about everyone else, but when a report references a column that is deleted, it's not easy for me to figure out which column is missing.

Sometimes I remove the wrong one thinking it's the culprit. So I start deleting until I find the one, refresh the report to bring them all back, then remove the one that worked. Sometimes this doesn't work if the report gets saved and that's annoying.

Feature Request: Somehow make it easier to see which of the columns is missing. One idea would be to make the text for those items red. You could also put a red * asterix next to the column name in the menu.

Here's an example: I've highlighted in yellow the places I think would be great to be highlighted with Red Text or an Asterix.

Georgie

Hi @NeilKY,

If a column has been deleted from all source sheets and is therefore no longer available, an exclamation mark in a red circle will be displayed next to the column name in the list of columns in the report. Hovering over that exclamation mark will display a message that the column has been renamed or deleted - as seen below: 

I’d recommend scrolling down in your list of columns to find the deleted columns - you can then uncheck the boxes for those columns in the list to remove them from the report.

Does that resolve the issue, or would you still prefer to have the deleted columns marked in the places you highlighted? 

Or do you mean if a column has been deleted from some source sheets but not all of them?

Thanks,

Georgie