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
-
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?
-
The formula I provide above is how far into the year we are. I'm not sure I understand your question.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!