-
Target Date/Delta info vs Baseline in PMO plan template
Hello! I've read through several past posts related to this but couldn't quite find my answer. We are using the PMO plan template and have activated the baseline feature. My manager has asked if there is a reason to keep the Target Start/End date columns as well as the related Delta columns since they're basically the same…
-
I have a "Current Project Log" with 2024 accounts. How do I move to "2024 Log" & keep dashboards?
Hello, Due to the size of our log I can only keep 1 year's worth of data in a sheet. I have monthly and YTD metrics/dashboards that pull from the current sheet. I need to move 2024 into a new sheet to make room for 2025 projects, but I know doing this will cause issues with the dashboards. Is there a way I can do this…
-
New Column Type: Time
In Sept 2023(ish), Smartsheet introduced a TIME function. To further utilize this function, a new column type should be added, called "Time." This column type will function similarly to the "Date" column type in that it will only accept values formatted in a specific way and, most importantly, can be used to trigger…
-
Automatic Phase from WorkBreakdown
Hello all! I'm modifying the Simple Portfolio Work Breakdown Schedule and having a little trouble. I like the way the Work Breakdown structure works but I'd really like an automatic way to track which Phase something is in. I know I could just add a column and manually select which Phase tasks and sub tasks are in, but I'm…
-
How can I use a calculated duration that uses my own formula?
I want to use my own formula to calculate duration. I've added a Calculated Duration column, but I can't select that column in my project settings. What governs what column you can select for your duration column?
-
Assignee reporting for all tasks during specific date ranges
I have been trying to create a report that shows all the tasks my team have on each week. I found some guidance in a community post about setting filters based on the start and end date. However I have found this doesn’t provide quite what I need so I was wondering if someone might be able to help me. Basically, I want to…
-
More Gantt Timeline Display Options
Due to limited screen space, I find the available Timeline Display options either far too dense to be useful, or too expansive. I propose: more Zoom settings. my issue is really that the zoom settings correspond to the heading incremements. my usability issue would be mostly resolved with more zoom level granularity. more…
-
Merged: "Include Parent Rows" option available in Reports --- Similar to Sheet Filters
This discussion has been merged.
-
Customizable Axis Values in Smartsheet Dashboard Graphs
It would be useful to have the ability to customize the horizontal and/or vertical axis values for graphs so that series of graphs can present data in line with each other. In our instance, we have created a dashboard containing all the members of our team and their projects. We have separate stacked bar graphs for each…
-
Health Icon Formula Help
Hi All - Longtime lurker, first time poster. I am attempting to add a Health Column to a smartsheet created by a colleague. I have been in the forums checking answers to similar, and tried to kluge my own formula together, but I've either missed the logic or I'm trying to do too much. What i'm trying to achieve rollup…
