-
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.
-
Highlighting Gantt Chart Date Columns
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 suspension period. Is there anyway to do that? If not, can I submit that as a feature…
-
Planning Calendar conundrums
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 trying to figure out the best way to handle that. Would I only be able to do it using…
-
Lock Gantt view date on Dashboard from a report
Hello, 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 checked to start at today's date, but it doesn't translate to the dashboard. I don't…
-
report: take over colors in grid view of a project
Hello, 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 (file 1). --> Until now all fine thanks to the "link from other cell of sheet" this has…
