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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
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))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!