-
How to use Smartsheet's legacy resource management function to highlight conflicts and auto change
Hello, apologies in advance if this appears to be a rather basic enquiry, however, I'm not familiar with Smartsheet's legacy resource mangagement tool. I've had an enquiry from a colleague who has a Gantt chart sheet showing his team's tasks (as below). He's wanting the sheet to be able to add holidays for people and for…
-
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 - 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…
-
Calculated parent % complete issue
Hello - We are using one of the templates to track a project. We track % complete at the lowest level and then use the parent rolled up % complete. We are seeing a very strange error in the parent % complete. I have attached a few examples that show the problem. You can see that the cost rolling up is not the same as the %…