# How to show % complete compared days in a year

Hello, I'm new to Smartsheet and I've built a few widgets but I'm currently having trouble with one I'm trying to build.

I'm trying to create a widget to show the percent completed of a project compared to the year completed. I have several projects that are needing to be added up to show a % and want to compare that with the percent completed of the year.

EX: I've completed 30% of the 20 projects and we're only 22% completed with the year. Can we create a widget to show that comparison?

Thanks!

## Best Answer

• ✭✭✭✭✭✭
Answer ✓

The formula I provide above is how far into the year we are. I'm not sure I understand your question.

## Answers

• ✭✭✭✭✭✭

You would first have to calculate the percentages of projects complete. How you do that exactly is going to depend on the structure of the data. Then you would be able to show the percentage of how far into the year we are using

=(TODAY() - DATE(YEAR(TODAY()), 1, 1)) / (DATE(YEAR(TODAY()), 12, 31) - DATE(YEAR(TODAY()), 1, 1))

• Thank you! OK, I have that completed, below. How would I show that to the % completed in the year now?

• ✭✭✭✭✭✭
Answer ✓

The formula I provide above is how far into the year we are. I'm not sure I understand your question.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!