nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Easily identify all Reports impacted by a column change or removal

Ami Veltrie

Need a way to proactively search (query a 'where used') on a column name to see all the Reports its used in.

Sign in to vote!

Find more posts tagged with

Idea Submitted

columns

report column

Comments

Kam Pierce

Would be very helpful to be able to see a summary list of all the Reports that are using information from that Sheet. Currently the only option is to see where a column in a sheet is being used in a formula in another sheet. But when trying to update column name in a Sheet, there's no way to generate a list of all the Reports where that Sheet column appears.

malden

Totally agree, this is needed.

Chizu Hieida

I want to make some structure change to particular sheet. (Especially Primary column) However, before I can change that, I need to find out how many and what reports are using this sheet as it's source to make sure nothing will break.

Anything used in cross-sheet reference formulas are easier to find out but Smartsheet support said there is no way to know what reports are running using that particular source sheet.

As we build more solution and share the source sheet with others, sometimes structure change is needed but I'd love to avoid breaking reports, so I'd like to find out before I make the change.

This function would come in very handy especially I inherited this sheet when I go hired.

Thanks!

Pauline J

Yes!!! I need to do this today! =-)

Dave Geyer

+1000

Ami Veltrie

In addition, we need a 'where used' feature for Report Filters as well. The filters continually break, resulting in broken charts because we can't easily query where those columns are used.

Quick Links

Trending ideas

Ability to duplicate dynamic views
We need the ability to duplicate (copy) an existing dynamic view to other sheets. We use templates and Smartsheet Control center, but when creating a new sheet (using SCC or Save As New) the dynamic view(s) are not also copied/duplicated. This creates a LOT of manual re-work. It'd be great if, from the Dynamic View…
Legacy Dropdown Functionality Option
Good afternoon, Recently there was a change that made searching a dropdown by typing inside of it switch from an exact match method where typing S would only show entries that begin with S to a search within method where typing S would show all results with the letter S in them. I can see how this would be beneficial in…
Custom Branding on Update Request Automations
Custom branding works on Alert type automations, but it would be great if that same branding was applied to Update Request automations as well.