How to show % complete compared days in a year

Justin G

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!

Paul Newcome

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

Paul Newcome

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))

Justin G

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

Paul Newcome

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

Test Case 123

That's great @Paul Newcome! I came across this thread and found this to be really helpful. Any chance you could help with the same formula but for a fiscal year rather than calendar? My fiscal year begins 7/1 and ends 6/31

Test Case 123

I was actually able to get it with this formula:

=(TODAY() - DATE(YEAR(TODAY()) - 1, 7, 1)) / 365

Getting the hang of SmartSheets 😀