-
Assistance Needed with Updating Month-Wise Data and Dashboard in Project Management
Hello everyone! I've recently taken over a project that was previously managed by someone else. I've observed an issue in the project's dashboard where the month-wise data, used for generating graphs, is only available until May (please refer to the attached image). Upon inquiry, I learned that the sheet containing the…
-
Calendar view in Dashboard
We have a sheet that acts as our project calendar and use start/end date columns to show them in calendar view across multiple days (to show duration). How can I get this same view of this sheet (or the report from sheet) in a dashboard. The report widget only appears to generate a gant view.
-
Copy changes from Clone Workspace to Live Workspace
Hello all, We are working on a Workspace for a client and they have asked various changes to be made on their Workspace. We created a Clone Workspace to implement all changes and make sure it works correctly. The requested changes had to do with: Adding new columns to a sheet & update columns order Adding column formulas…
-
Forumla help sought so cancelled tasks are not counted as at risk
This formula surfaces 'At risk tasks' to a project rollup dashboard report. It does so based on the criteria of due date in the past and status other than complete. =IF([End Date]@row <> "", IF(AND([End Date]@row < TODAY(), Status@row <> "Complete"), 1, 0)) Question - What needs to be changed so that it does not surface…
-
Can you Log a Cell In time?
Within my project sheet I have formulas set up to show me the present of Target duration vs actual completion date. The parentage in cell will change as we close out projects. Is there a way to track/Log this cell as it changes so that I can create a line graph to see our patterns over time?
-
Metrics Widget - Summarize from Many Sheets in a Workspace
I want to add a Metric widget to a Dashboard that totals the number of projects that I have in another workspace. Each schedule (sheet) in that workspace has standard summary fields that I use in Reporting. When a new schedule is dropped into the workspace, it is automatically picked up by all the reports that look at that…
-
Multiple Checkbox's for sheet summary into a dashboard.
Good afternoon, I am looking to see if this is possible. I am looking to have a dashboard automatically populate with a new row when another is "complete". Which I am able to accomplish with automation tasks. The issue is building the dashboard that has multiple columns of checkbox's. Please see the photos below for an…
-
Embedding a powerpoint in a dashboard
The instructions for embedding a pptx in a dashboard look straightforward. I've opened my pptx on the web and copied the embed link, but when I paste it into the Web Content Widget, I get the error "We couldn't find any embeddable content from this link. Please check the link and try again." I'm following all the…
-
Formula for Status Summary Report and Project Task Completion
Hi Smartsheet Team, I have the following charts. Left one, I retrieve the data from Status Summary Report. On the right side, I have the formula to calculate the Project task completion. However, you will see the complete % is different between these 2. My "Not Started" in Sheet Summary formula is =COUNTIFS([Count of…
-
Connecting to Amazon QuickSight
Hello, we currently utilize amazon QuickSight to build automated dashboards from other websites. Would it be possible to connect the data collected on Smartsheet to build automated dashboards on QuickSight?
