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 Smartsheet16Ben 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 Smartsheet177Richard 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…
Using Smartsheet27David Hayes
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 Functions213Alexander Wirtz
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 Smartsheet18Jonah 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 Functions15Brett 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 Smartsheet2Jerry 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 Smartsheet55Mary 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 Smartsheet14Rick 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 Smartsheet3Koen 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 Smartsheet500Jef 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 Functions127Mike 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 Smartsheet23Phil Schmitt
I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual.
I want to count how many of t…
Formulas and Functions36Martina Barnett
I am trying to build a nested at risk formula based on the following triggers.
-End date is today and Status is not complete it will trigger
-There is not enough time between today and the end date for the duration period left. So, if dura…
Using Smartsheet23Kayla Johnstone
Anyone else seen this? Not sure if it has been like this since the start or if its a new thing...
Is there a setting to correct this?
I'm trying to count the tasks in my gannt per each week in a separate grid. Then i'll make a graph representing work overloads throughout the year.
Here is my formula that calculate 0 every time (at least not an error) :
Formulas and Functions53Assaf Elad
I am attempting to use conditional formatting to change the color of my Gantt bars; however, the conditional format is not being applied to the Gantt bars.
Here is my conditional formatting
You can see below that I specify…
Using Smartsheet43michael anderson
When I select Gantt view some of my child tasks have work day and non-work day shading. Non-workdays are light grey and work days are White. This occurs randomly on the sheet. Several child rows have no formatting and some have the gre…
Using Smartsheet23BJ Patnode
I know you cannot use a formula in a "% Complete" field. Is there a way to update "% Complete" from a formula in another column (something like a "helper" column)? I have a "Task Status" column wit…
Formulas and Functions25BJ Patnode
I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet.
The strange t…
I need to import an existing project plan (call it A) into an already project plan (call it B).
A is under a different corporate account than B.
I have access to both. I need to merge the 2 project plans into 1. The question probably has b…
Using Smartsheet47Francois Chagnon
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 Smartsheet260Project User
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 Functions453Becca Grunbaum
Created a report and added the report via widget to the dashboard.
Realized, that the lines are not matching....Content line height is obviously different to the GANTT line height.
The report itself looks good and correct - the change is o…
Using Smartsheet36Gottfried Reichl Mueller