Reports with multiple source sheets: Highlight Columns Missing from specific sheets

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.

Sign in to vote!

Find more posts tagged with

Reports

Idea Submitted

report column

Comments

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:

AD_4nXdwG7EAABJRF8DrxgWsTmGh6MQBnnsXfb6lp83-F2BjWIbjob2yMTRusaIjgLDDz-MVpFDiC0pv3DrNmt1nVHNH3z6sOqLq1F8WK4IuelSqELG9t-28OEfJlPhlCJHTfUiRAXyhDQ?key=kJhfz7tJqh-PlLw2lQloMzht

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

NeilKY

That's exactly what I mean, but in my case yes, I also need it to be displayed (Maybe even with a different symbol) if it's missing from one of the sheets and not all of them.

Quick Links

Trending ideas

Report Widget Capability - Drag & Drop to create Report Widget in Dashboard from Workspace Panel
Hi, I was creating new dashboard and thought it'll be so nice to have easy drag and drop Report widget capability from Workspace Panel since I always group set of reports under one folder (for ease of finding them what goes on the dashboard). I think this would be great time saver especially if you have similar name…
Resource Management Plan Settings in Control Center - add Client and Project Code fields
In the Resource Management Plan Settings in Control Center, there is no way to link the Client and Project Code fields even though they are not Custom fields and part of the first 3 fields you enter when creating a new project. I can't select them in the Custom Resource Management Information Fields because they are not…
Asset Sharing should default to View, not Edit
Since the license model has changed, the option to Share should default to VIEW, not EDIT. The View option allows less-experienced users to share that way by default, and share as Edit only when needed. This allows for less cleanup during true-up. This also prevents users from adding provisional licenses unknowingly.