How to get project overall delay in days in Smartsheet

marmanlive

Hi

While we use the Baselines on the task level to see the delays per task, is there a way to grab the overall project delay in days and also show it in the Dashboard?

Thanks for any prompt

Regards

/Marat

kowal

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.

marmanlive

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)

2024-10-17 18_26_59-HV _ Due Next Week.png

Uploaded Oct 17, 202451.34 KB

kowal

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?

marmanlive

@kowal

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!