I have a very long dashboard and have been playing with ideas to make it more manageable. One option I would appreciate is to be able to anchor to specific parts of the dashboard so the viewer can access the topics that are of interest to them.
Sign in to see the current vote count, add your own vote, or leave a comment.
@Anonymous2023 Have you tried creating a WorkApp with different Dashboard "Derivatives" assigned to targeted Roles? For instance, I have a "Main" Dashboard where I have created different "Derivatives". Each "Derivative" Dashboard is pulled into a singular WorkApp where I defined specific Roles to specific End Users so that they only see their dedicated Dashboard. Since the "Main" and "Derivative" Dashboards point to a core selection of underlying Smartsheets, then the out-of-the-box Automation Workflows and regularly run API Python scripts maintain near real time data integrity.
@Erin Horiuchi Green would this work for people without a Smartsheet account? This is intended to showcase our data to the general public, not for internal use.
@Anonymous2023 I am going to run a test on my WorkApp now. If this does not work, then you are stuck with storing the Dashboard in a Workspace that has been setup for External Use.
@Anonymous2023 I was able to successfully add an External Email to the WorkApp Role. What was scary is that I did not have to assign the External Email to the underly Smartsheet. Something to consider from a Data Privacy and Protection perspective. Hopefully, you have an internal IT architecture form that you fill out and IT signs of on security compliance so that you are not stuck with any mislaignments. I always ensure I peanut butter spread the accountability across all my business partners.
Problem Smartsheet environments quickly become cluttered with inactive Sheets, Reports, and Dashboards that are no longer viewed or updated. This creates confusion for users and significant overhead for admins, especially in large or regulated environments. There is currently no native way to automatically identify, notify…
Most customer's metadata houses their profile data, some from intake sheet and some either cell linked in or brought into metadata using formulas. Needs change after design and often the new data point needed comes from non-metadata templates, which can cause a blocker if methods used are those above. If it were possible…
Having the ability to auto-resize the Calendar App view based on the widget size is needed. We have a "Due in 7 Days' calendar for our dashboards and would like it to be anchored at the top right. Unfortunately, as currently designed, the calendar takes up a significant amount of space and must be moved to the bottom.