% complete estimation issue

ALAIN-STEPHANE

Hi everyone ,

Happy Easter !

I am a bit concerned with tracking project progress with SMARTSHEET.

I understand that Smartsheet project planning principle is based on duration, and that way a task wich lasts much is more weighed than a task which takes less time.

But in real life , it is not often the case , to prove this , check my example regarding the construction of a kitchen in concrete structure .

In that case , even if the finishing works take more time than the structure works , the structure works is more costly and require more ressources .

So in this view , completing the structure works means logically that the overall project has high percentage complete , but in my example , when the structure works are over , the overall project is just 31 % complete , that's a non-sense in my contexte .

So I would like to know if someone can suggest me a workaround . 

Thanks in advance .

Bassam Khalil

Hi @ALAIN-STEPHANE

Hope you are fine, i advise you to add the following helper columns to calculate the actual progress:

1- Actual cost to date,

2- Progress = Actual cost to date / Budgeted Cost

Bassam Khalil

Hi @ALAIN-STEPHANE

Hope you are fine, i advise you to add the following helper columns to calculate the actual progress:

1- Actual cost to date,

2- Progress = Actual cost to date / Budgeted Cost

ALAIN-STEPHANE

Hello @Bassam.M Khalil ,

Thanks for your reply .

It's an idea that I will consider , but it means the % complete column will not be useful anymore .

Bassam Khalil

@ALAIN-STEPHANE 

No, you can use  % complete but for sure not to determine the weight of the activities. Please help the Community by marking it as the accepted answer.