# Using colum % complete

Options
✭✭✭

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%.

José Ibanez, ing. Jr

Ingénieur Manufacturier

Manufacturing Engineer

• ✭✭✭✭✭✭
Options

You would use something similar to

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

• ✭✭✭
Options
```To calculate the percentage of 2 jours, I want to know how to do it
```

José Ibanez, ing. Jr

Ingénieur Manufacturier

Manufacturing Engineer

• ✭✭✭✭✭✭
Options

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%

• ✭✭✭
Options

Hi Paul,

Yes, Can I generate it automatically?

I can to use formula.

José Ibanez, ing. Jr

Ingénieur Manufacturier

Manufacturing Engineer

• ✭✭✭✭✭✭
Options

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

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

=Jours@row / PARENT(Jours@row)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!