# Formula to track % complete of a fabircation component in a row

✭✭✭✭✭✭
edited 12/09/19

Good evening,

I will try and explain this without messing up

• We are using smartsheet to track fabrication of product
• each row is an item we fabricate
• each item has a budgeted amount of time per task designated in a column
• the sum of alloted time is
•  =SUM([Budgeted Python Per Piece]91 + [Budgeted Fit Up]91 + [Budgeted Weld]91 + [Budgeted Unload]91 + [Budgeted Admin]91) / 60
• as the product goes thru our shop we have a checkbox column next to each of the budgeted time columns for each of the above and want to track the % complete for each piece
• So we would like the  % complete to tally everytime a check box is checked so that when all  5 tasks have been completed we are at 100 complete for that product
• What type of formula would we use to get this done?

Thank you

• We need something similar. I would love to see what other users are doing. Currently we have to manually update the percent column to 100% each time a task is complete.

We have tried the predecessor option as well, but it limited some of our other features.

• ✭✭✭✭✭✭

Hi,

Are the task always completed in the same order?﻿

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

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.

• ✭✭✭✭✭✭

Hi Yes

They are always completed in the same order but sometimes some tasks are not needed.

• ✭✭✭✭✭✭

Ok.

Try something like the below formula to start.

=IF(F1 = 1; 1; IF(Admin@row = 1; 1; IF(Unload@row = 1; 0,8; IF(Weld@row = 1; 0,6; IF([Fit Up]@row = 1; 0,4; IF(Python@row = 1; 0,2))))))

The same version but with the below changes for your and others convenience.

=IF(F1 = 1, 1, IF(Admin@row = 1, 1, IF(Unload@row = 1, 0.8, IF(Weld@row = 1, 0.6, IF([Fit Up]@row = 1, 0.4, IF(Python@row = 1, 0.2))))))

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Hope that helps!

Best,

Andrée

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.

• ✭✭✭✭✭✭

Hi Julie,

Does the below formula help you or do you have some other requirements?

Best,

Andrée

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.

• ✭✭✭✭✭✭

HI Andree

Thank you

Trying now

• ✭✭✭✭✭✭

Happy to help!

Let me know how it goes!

Best,

Andrée

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.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!