Remove Columns in Sheet and have it removed from Report

System · 05/02/24

This discussion was created from comments split from: Welcome to the online Smartsheet Community!.

JanelleGraf · 05/01/24

Hi, I am new to SmartSheets and new to the community. If I change, remove, edit columns in a Sheet is there a way I can apply the same changes to the corresponding reports?

Andrée Starå · 05/01/24

https://community.smartsheet.com/discussion/comment/434038#Comment_434038

Hi,

I hope you're well and safe!

Unfortunately, it's not possible now, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Genevieve P. · 05/08/24

https://community.smartsheet.com/discussion/comment/434038#Comment_434038

Hi @JanelleGraf

If you change the Name of a column in a sheet, that name will automatically be updated in the Report.
- Note that if you're referencing multiple sheets and the name only is changed in 1 sheet, this will appear as an indented column reference in the Column list. Here's more information: https://help.smartsheet.com/articles/2482752-renamed-columns-underlying-sheets?utm_source=web&utm_medium=web&utm_campaign=release-notes&_gl=1*ahef4m*_ga*Njg2ODAzNzcwLjE2ODQ1MTA3NDI.*_ga_ZYH7XNXMZK*MTcxNTE2ODYyNy4yNC4xLjE3MTUxNzM4ODkuNDMuMC4w&_ga=2.12152626.704478003.1715014252-686803770.1684510742#toc-to-work-with-renamed-columns-
If you delete a column from a sheet, and that sheet is referenced in a Report, the column will appear in the Report with blank data. You can find deleted columns at the bottom of the column list:

If you change a column by adjusting the type, this column is now see as a new column, as if you deleted it and then added a new one into the sheet with a new name.
- This means you will need to re-select the column in your Report.
- If your Report has more than one sheet, that newly changed column will be a separate column than the other sheet's columns, even if it has the same name. You will need to re-select it to show the new data/column type See: https://help.smartsheet.com/articles/2482080-select-columns-to-display-for-report-builder

Cheers,
Genevieve

Remove Columns in Sheet and have it removed from Report

Answers

Categories