Pretty long project, spanning a bit over a year. I'm about halfway through it & the Gannt Dates started getting weird. In the image, Look at "Floors", predecessor 232. The scheduled start date column says 8/13, …
We are trying to see if there is a way to view a Gantt chart that overlays projects that are in multiple sheets so that we can make sure our department is not spreading itself too thin/which projects have overlapping timelines. Is there a …
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, s…
Sorry If this is a repeat but the first post seemed to have disappeared.
My Goal is to have the Top row #1 Where that checkbox is to say what the total of completed of all the subtaks below. For example the Level 4 is showing 100% complet…
Formulas and Functions21Grant Graves
I'm keen to look into options to report on project progress against schedule.
Generally we set a project programme, then progressively update %Complete against lines and the project progresses.
The progress bar works well as visu…
Formulas and Functions285Chris_Bick
My organization is moving from MS Project to Smartsheet and there is a functionality on the progress bar of the gantt chart in MS Project that I would like to see if Smartsheet can do. The Update Progress bar that shades % Complete in MS P…
Formulas and Functions42Nick Casiday
(Image) 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.
(Image) I would like to retu…
Formulas and Functions21Griffin Fujii
I have a question about how to have predecessors or just tasks in a schedule to automatically update when they are moved in the schedule. I am trying to create a production schedule for our Sheet Metal shop and it is created with…
Formulas and Functions105ryan.diamond55371
I want to use smartsheet as an international project management tool. One thing is driving me creasy.
I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions309Alexander Wirtz
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 learni…
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 synt…
Formulas and Functions32J Fitzpatrick
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 …
Formulas and Functions680Becca Grunbaum
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but…
Using Smartsheet430Project User
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 assigne…
Using Smartsheet21Ben Cutler
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 targ…
Using Smartsheet256Richard Heath
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.
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 sun…
Formulas and Functions32David Hayes
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 generall…
Using Smartsheet32Jonah B @ Job Shop
I would like to figure a way for the Status Column to auto fill depending on what the % Complete says.
0% = Not Started
1-99% In Progress
100% - Complete
Conditional Formatting is not the way to go and I can't figure out the …
Formulas and Functions21Brett Macias
I am using Smartsheet and I am involve in 3 projects and all are main and lead roles. I made 3 separate sheets for each project but I realize each projects affect the other projects and then sometimes the predecessor is in another sh…
I have several projects that were suspended due to Covid issues but are starting to open back up. I have to push out everything due to this suspension and I would like to highlight (or just delete/hide) those date columns during the suspen…
Using Smartsheet11Jerry Tice
I'm trying to run a single report of my 5 project schedules so I can quickly see aligning milestones and deliverables. However, when I run the report, all of the predecessors become unconnected and the columns report 1 predecessor. This is…
I am a fairly new SS user and am owner/admin for a large project/Gantt sheet that is shared internally with other Project Managers, who are also fairly new to SS. They have edit permission, but are not admins. I have set the project option…
Hi, Community! I am wondering if anyone else is using SmartSheet for an institutional planning calendar. I chose a template of project with gantt. Most of the tasks on the calendar, however, are annual, bi-annual, semi-annual, etc. I am tr…
Using Smartsheet62Mary Vogt
I am pulling data into a report and displaying on my dashboard. The gantt view always starts on March 15th. Executives viewing the report want to have it start on today's date. The both the source sheet and report's gantt view is…
Using Smartsheet22Rick Benton
her's my build.
I have a project file (file 1) with all details of different project but always with the same structure with different colors.
Out of that I created a second PM file (file 2) with links to that main Project file (fi…
Using Smartsheet1Koen Placke
Hello - I have searched the community and have found a "work-around", but it doesn't work. I am trying to show a calendar view of a clients project on a client dashboard. I only want them to be able to see it. I don't want them…
Using Smartsheet738Jef Forward
I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week.
I am easily able to plot cost for items that begin or end in a calendar month, but not…
Formulas and Functions197Mike Liggett
When I try to add one particular contact that I added to my contacts list to the Assigned To field on a Gantt chart, it won't display the Name... just the person's full email address. This is only happening for this one contact - the rest …
I have several columns I need to export with my Gantt chart but only the standard Gantt columns seem to export. Every new column I added to the Gantt chart does not export. I even re-loaded the XML back into Smartsheet and the data is m…
Using Smartsheet31Phil Schmitt