-
Returning Start and End Dates
Hi All, I am trying to get the MIN or start date of a range that only grabs from the row with the same phase. Keep in mind these Start and End dates in the project plan below have dependencies enabled. I would like to return the MIN Start date in the Start Date Metrics column row 3 in image 1. The range is the Actual /…
-
Resource Management Tool
I'm looking at how I can migrate project plans (Omniplan) into Smartsheet to then use the resource management element to see people's capacity and adjust the schedule to smooth delivery. Has anyone done something similar or have any learnings they can share with me please? Also, attached is a screenshot of the resourcing…
-
Need help with 'If , Then' function to subtract Duration Values
I'm setting up a Construction Schedule with Variance calculations as the 'Near Term' baseline solution that's been quoted as coming for a few years now has not materialized yet. Unfortunately after searching the forums I'm not seeing syntax examples that work for what I need to do. It would be helpful for me at least to…
-
How to link the health column to show an accurate status of at risk tasks.
Hi All, I am looking to find a way that I can link (create a formula) so the health column shows a traffic light system for the status of the task. I want to aim for this to detect the percentage of completion of a task in relation to the finish date. For example, if the finish date is only a couple of days out and the…
-
One person has multiple jobs on one day
Hi, I'm looking to adjust my sheet based on one person having multiple jobs in one day. What I'd like to do it have it be that each person has only one job per day. Ideally, SS would be able to look at all other jobs this person is assigned to and adjust the start dates of other jobs based on available slack time (away…
-
Gantt Chart status bar doesn't appear to reflect progress
Our PM's are experiencing a few issues with the Gantt Chart, and I hoping someone can help. In some instances, per the attached, the overall status suggests that the program is ahead of schedule. This is despite Sub-child 2a being on target. Any thoughts why this would occur? We also utilise a formula that suggests how may…
-
Date Range Printing
Hi, I am having trouble printing a specific date range in gantt view. I've selected the dates, tried printing, but it shows the full spread and never reduces to the specified date range. HELP! Thanks, Simon
-
Elapsed time - 24hr workday - Display bug?
See the attached pic. * The sheet is set for 24hr workdays. Mon-Fri. * There are 2 tasks. one with duration 7d and one with duration e7d. * The e7d task does not display 7 days of working. The gantt chart bar does not show sunday as a working day. * Resource view DOES show sunday as a working day. Bug? Also, the "roll-up"…
-
2 pet peeves - Printing and Filters for columns
Not really a question. More of constructive criticism/asking for better developed features. I use Smartsheet as a scheduling tool at our company, We use master project sheets and a series of project reports and company reports. We generally use Gantt Charts so mostly these comments pertain to that view. For the most part,…
-
Status corresponding to % Complete
I would like to figure a way for the Status Column to auto fill depending on what the % Complete says. For instance: 0% = Not Started 1-99% In Progress 100% - Complete Conditional Formatting is not the way to go and I can't figure out the right If/Then statement to use. New to this world so don't think down on me too much.