Tracking Variance in Counts (up or down)
JKremer
✭✭✭✭
We count completed projects
What I want to see is:
On 7/16/22 we had 48 completed
Today we have 50 completed
So we are Up by 2 since 7/16/22
Is there a design or a formula to capture this?
Answers
-
Looking for the exact same thing.
I have a weekly dashboard of our orders, would like to show the variation on one week.
-
Hi @JKremer,
Depending on how your project data is tracked, something along the line of =COUNTIFS(Status:Status, "Complete", Completion Date:Completion Date, >=DATE(2022,07,16) should count for those 2 projects.
If you'd need further specfic advise about your project sheet, please make sure to include a screenshot where any confidential data has been hidden.
I hope that this can be of help.
Cheers!
Julio
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 430 Global Discussions
- 150 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 500 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!