Using colum % complete

JOSE IBANEZ

Hi,

I would like to know how I can assign the porcentage in the % complete column. If my stage has a duration of 20 days and I want to assign for each day%.

Paul Newcome

You would use something similar to

=(TODAY() - [Start Date]@row) / Duration@row

JOSE IBANEZ

To calculate the percentage of 2 jours, I want to know how to do it

Paul Newcome

I don't understand what you are asking. Are you trying to just generate the percentage of 2 from 20?

Such that the rightmost column in your screenshot would read something along the lines of...

10%

10%

25%

15%

10%

15%

15%

JOSE IBANEZ

Hi Paul,

Yes, Can I generate it automatically?

I can to use formula.

Andrée Starå

Hi @JOSE IBANEZ

Try something like this.

=Jours@row / PARENT(Jours@row)

Did that work?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

@JOSE IBANEZ Yes you can using the formula @Andrée Starå provided above.

=Jours@row / PARENT(Jours@row)