New Project Plan...3 questions
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.
- 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?
- 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.
- 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!
Answers
-
Hi @Michele R.
- 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)
- 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.
- 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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!