Control Center Dynamic Report: SHORTCOMING IN DESIGN FOR ARCHIVE

So often Smartsheet creates really nice features - they just are not well thought out.

Dynamic Reports when Archiving - is just one example.

I set up the Archive Process before I had Dynamic Reports set up - NOW - EVERY TIME a new project is provisioned - it RESELECTS the Sheets in the Archive Space that were in the Dynamic Reports.

CURRENTLY THERE IS NO WAY AROUND THIS

Which means EVERY TIME a project is provisioned - I have to go into my 8 Dynamic Reports and MANUALLY DESELECT the Sheets that should not be included.

How does that make ANY SENSE???

The OTHER nice (not) FEATURE of Dynamic Reports - is if you INCLUDE a sheet from a project that was not provisioned by Control Center - it does you the FAVOR (NOT) of taking that sheet out of the Dynamic Report.

Sign in to vote!

Find more posts tagged with

Idea Submitted

Comments

Ramzi

Just ran into the same issue - my problem is archived sheets are NOT removed from dynamic reports when projects are archived. Ugh.

isa_altium

@Ramzi - I did find a setting in the Archive that says "remove from dynamic report scope" (or something like that)... the workaround I found is to DELETE the report from the Archive workspace - then you can move it back...I think it changes the id so CC can't find it anymore... ugly solution - I know...

One thing to try (that I have done for other issues around Dynamic Reports) is to take the Dynamic Report OUT of the CC blueprint - save it - reselect the correct sheets to include - and then add it back into the CC Blueprint... I can't remember if I tried that on the archived reports or not... I don't think I did - I think I just deleted the sheet out of the workspace...

Quick Links

Trending ideas

Warnings when approaching functional sheet capacity
Although we are extremely proficient when it comes to reducing load on our smartsheets (we use pivot, data mesh and data shuttle extensively), we still find ourselves hitting capacity limits (mostly because of the number of columns in conjunction with some pretty complex formulas). Breaking up data between sheets and…
Timeline Widget - Custom Colors
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…
Workflow Automation print in PDF and/or export to Visio
Be able to print and/or export Workflow Automations in PDF and/or export to Visio. this would be used for document control and troubleshooting aid