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
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!