-
Can I hide predecessor lines in a gantt chart?
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 the predecessor lines? Thanks!
-
I want to only show the summary Gantt chart on my dashboard
I want to show a summary of my epics in a Gantt chart on my dashboard, but it's only showing the Gantt for tasks. How can I show this summary?
-
Gantt View - Option to split horizontally
Currently switching to the Gantt View splits the sheet/screen vertically. It will be nice to have an option to have the Gantt View to split the Sheet/Screen horizontally.
-
Gantt view - Open to Today's date
I tick the box "Open to today's date" on most of my plans and it seems to work fine. However I have one sheet that won't save the setting. Basically it's a holiday calendar for the team to record holidays and I use it in Gantt view so you can clearly see overlaps. It always opens in Gantt view so that setting holds.…
-
How can I set a date to be the same day of every month?
Hi, I need to make a Gantt view sheet for working on a single specific project that lasts for a month, and then starts all over again. This project will have the same tasks with the same deadlines every month, so I need to be able to set start and finish dates to be on the same day every month, so that it sort of "resets"…
-
End Date Formula Work-Around when Dependencies are Enabled
Hello! I am working in a sheet where I need dependencies enabled because we are using the GANTT view to show in a report on a dashboard, however I also need the end date of that sheet to be calculated (it is calculated based on another date in the same row). When dependencies are enabled, I'm not able to put a calculation…
-
Conditional Formatting applied to Gantt View?
Is there a way to apply the conditional color formatting to the Gantt View bar itself?
-
task status based on expected % complete
I am trying to write a formula that will return red, yellow, green, or gray staus symbols based on the following criteria: Gray - If actual % complete = expected % complete Green - if actual % complete > expected % complete Yellow - if the actual % complete is within 10% below the expected % complete Red - if the actual %…
-
Disregarding N/A in Formula
Hi, I've been using this formula: =IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary Risk]@row, 1))) < 5, "Blue", IF(SUM(VALUE(RIGHT([Overall Summary Cost]@row, 1)), VALUE(RIGHT([Overall Summary Schedule]@row, 1)), VALUE(RIGHT([Overall Summary…
-
Formula under Duration in a Gant chart
Hi there, I'm new to smartsheet I want to switch from MS Project to smartsheet to set up the planning schedule. I know we can assign multiple of people to a task but at the planning/biding level, I just want to juggle with the number of resources to set the best outline. I would like to set the work (total effort to…
