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

NeilKY · 01/07/25

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 · 01/08/25

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 · 01/08/25

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.

Smartsheet Product Feedback & Ideas

Smartsheet Product Feedback & Ideas

Sign in to submit new ideas and vote

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

Idea Submitted · Last Updated 01/07/25

Comments

FAQs and Guidelines for posting Product Feedback Ideas

Quick Links

Categories

Trending Ideas

IDEA: Populate Available Field Names After Typing Double Curly Brackets {{

Date Columns with Formulas

upload fields