How to get project overall delay in days in Smartsheet

marmanlive
edited 10/17/24 in Smartsheet Basics

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

Answers

  • kowal
    kowal Overachievers Alumni

    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.

    Tomasz Kowalski

    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!

  • marmanlive
    edited 10/17/24

    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)

  • kowal
    kowal Overachievers Alumni

    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?

    Tomasz Kowalski

    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!

  • marmanlive
    edited 10/17/24

    @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!