-
Smartsheet "Tabs" within a Teams Channel
Hi all, When adding the Smartsheet tab within my Teams Channel, under About, it says: Add Smartsheet sheets, dashboards, and reports as Tabs in a Team channel, so teams can collaborate with a shared view of work. However, only Reports and Sheets are showing up as options. All of the Dashboards I have created are not…
-
Best Practices for Scalable Sheet Templates in Exec-Level Project Portfolio Reporting
Hi Community, I'm working on building Smartsheet templates that will support executive-level reporting across our project portfolio, and I’d love to hear your best practices and lessons learned. Specifically, I’m trying to design templates that are scalable, easy to maintain, and dashboard-friendly. Here are a few…
-
Program Management within PMO structure
I need to set up a Program (Multiple projects). What is the best way to do this within my portfolio? Set up each project in the program as a separate projects? add these projects as separate sections within one project plan? Ultimate goal is the have a status for the program and have the program report as a status in the…
-
Merged: Bring back ability to control indiv. bar colors on chart widgets
This discussion has been merged.
-
Ways to avoid 25000000 formula cell reference limit
We have a sheet that we use for time tracking for some of our projects. We have about a dozen people supporting projects and they may log their time multiple times a day. I have a SUMIFS formula that adds the duration for each client project. Formula: =SUMIFS(Duration:Duration, [Client ID]:[Client ID], [Client ID]@row ) I…
-
Summary sheet values don't update in dashboard without entering source sheet?
I have a sheet summary report on a dashboard and oftentimes the values will not update unless I go into the source sheet and manually save the updates. For example, the WEEK TIME OFF value often will not update week-to-week unless I go into that contact's sheet and save. I have tried adding a daily Chron automation…
-
Is there a way to update scaling on Smartsheet Dashboard graphs?
Hi, I'm having an issue where the graphs in the dashboard are auto scaling to the numbers in the table. I was hoping to get a scale of 100 for each of my graphs on my dashboard but there's seem to be no way to update this. Would anyone know how to update this?
-
Summary filed in sheet
Hi Team, I want to display the total amount below into dashboard And I guess I need to use below "sheet summary " , not sure how to get the total amount into the sheet summary Looking for ward to your reply, thanks in advance
-
Graphs on a Dashboard - Data selection and display
I am working on a dashboard that shows graphs from a constantly updating subset of data. Data is pushed from Snowflake into Smartsheet via a python script. Ive had trouble creating graphs on my dashboard due to the fact that I cannot select columns as a data set since my dataset grows and shrinks (Graphs only let me select…
-
Dynamic Dashboard Widget Size
Is it possible to have a Dashboard Widget expand or contract based on the number of rows in a report? I have a number of dashboards that are all the same, but the information varies greatly from report to report. I would like to consolidate white space as much as possible for the ones that only have a little information or…