-
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 %…
-
Iterative Functionality (circular reference) in smartsheet.
I'm currently trying to find a way to do a simple iterative count using the automation tools in smartsheet. Simple iteration is one of the most basic tools in computer based problem solving, so it seems like a good feature to have built into automation tools. The specific situation is that I want to track how long a card…
-
Dates start flashing after updating another task's predecessors
I have a project plan that I am now updating to establish dependencies. Everything was going fine until I updated one task's predecessors and a completely separate row's dates (and associated span in the gantt chart) started flashing. I'm guessing that there is some circular logic or something that might be causing this…