How to get project overall delay in days in Smartsheet
Answers
-
Hi Marat,
If you add one row at the very top of your project plan and indent all the tasks under it - this first row will be your entire project - so if there are delays in tasks that are under will impact the main top task.
Hope this helps.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Hi @kowal
Thanks for the prompt response.
That is exactly what I did before, yet the top row for Variance column does not return any value. I'm not able to put a formula in that cell either as it is a system column (for baseline calculation).
Maybe this is because I have sub-parent rows (3 levels of indent)?
Side note: I'm not sue if Baseline Status column returns the right value either. Parent rows mostly return Behind, yet the top row shows as On Schedule.
(see the screen attached)
-
Hi Marat,
so weird that the first row does not take automatically the dates from the rows under.
I just crated this 3 rows nano plan.
Maybe you have not created this sheet as project first that's why it's not calculating?
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
-
Can you please add another row between NEW and New 1 and indent New 1 and New 2 rows under it.
Please also include the column Variance in your screenshot, thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives