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 see the current vote count, add your own vote, or leave a comment.
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.
Totally agree, this is needed.
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!
Yes!!! I need to do this today! =-)
+1000
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.
It would be extremely beneficial to have the ability to manually assign colors to individual projects within the Timeline View. Currently, project colors are automatically determined by the Dashboard Theme, which limits flexibility and makes it challenging to visually differentiate projects in a meaningful way. Allowing…
As the smartsheet admin for Europe, it would be extremely helpful to be able to view all Automations / recurring emailed reports in one place as opposed to sheet level. It's almost impossible to ensure everything is working correctly / delete recurring emailed reports without this.
It would be nice to be able to deactivate all automations at one time when I need to work on a sheet. Then to be able to activate all of them at one time when I am finished. One of my sheets has 48 automations. It is extremely time consuming to deactivate them one at a time. Thanks! Freda
