# Calculating a percent

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

Hello,

I am struggling to calculate the % complete based upon Target Savings / Realized Savings. I am trying to track the % complete of task based upon how much of our target savings we have realized.

Any suggestions are appreciated.

Thank so much,

Katye

• ✭✭✭✭✭✭
Options

Hi Katye,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help.

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.

• ✭✭✭✭✭✭
Options

Just wanted to follow this as I track % complete pretty regularly. Curious if there's an easier way than what I am using.

• ✭✭✭✭✭
Options

Hello,

I have attached a screen shot of the columns in question. The task name represents the metric we are trying to track. The Target Metric column is the \$ amount or number we hope to achieve. The Realized metric is where we would track amount to date. For example, a target is to save 500k. For that month we realized 25,000. In the percent complete, we'd like to have the % complete be based off how much we have realized in comparison with the target and display as a %.

I'm not sure what formula could be used to achieve this.

Thanks for the assistance.

• ✭✭✭✭✭
Options

I figured it out. It is as simple as dividing Realized/Target in the percent complete column.

• ✭✭✭✭✭✭
Options

Great that you figured it out!

Have a fantastic weekend!

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!