New Project Plan...3 questions

Michele Rosenberg

Hello smart people :=D - I'm back and doing something new! I am creating a project plan from a template and trying to do a couple of things but having some challenges.

1. I want to insert Actual Start/End dates and have those dates drive the red flags. How could I do that and what are the risks?
2. Why is my % complete not calculating when child fields are updated, some are working and some are not. Validated that they collapse correctly so believe they are related correctly.
3. My duration is calculating day one in total days and I do not want it to however I have not found a way to update the field, is there a way that I do not know of? I want the first day to be counted as ZERO.

I am happy to be working with you all again and look forward to seeing your challenges and learning from you all! Have a wonderful day!

Julie Fortney

Hi @Michele R.

1. Is there a formula in any of the At Risk cells? You can customize when tasks are flagged as at risk using formulas. For instance, if you wanted to flag any overdue tasks, you could use this formula: =if(and([End Date]@row<today(), [% Complete]@row<1), true)
2. Parent rows won't calculate % Complete when any child rows have a duration of 0. (Here's a help article on parent rollups: https://help.smartsheet.com/articles/765753-parent-rollup-functionality#:~:text=The%20%25%20Complete%20on%20the%20parent,a%20longer%20duration%20child%20row.) If you want to change that, you could disable dependencies to add your own formulas to the parent rows, but that removes your ability to use the Predecessors column.
3. Could you provide more detail on this request? Are you perhaps saying that you want the second task to start on day 1, not day 2?