Date Formula with Specific Criteria
Good evening Smartsheet Community:
I trying to create a formula that would give me the Number of Done in the Status Column based on Today's Date so I can see at any given time how many issues are done. If anyone has a similar formula they can share that would be awesome.
Thanks
Comments
-
Smartsheet Community I think I figured it out. This formula will count the Number Deployments for the Current Week (M-F), unless a resources does deployment on the weekend
=COUNTIFS(Status:Status, OR(@cell = "Done", ISBLANK(@cell)), [Deployment Date]:[Deployment Date], AND(@cell >= TODAY(-5), @cell >= TODAY()))
I will test this out for the upcoming week and let everyone know my results on Friday
-
Spoke too Soon. Back to the drawing board. If anyone has this formula,,can you please posted it?
-
What is your exact criteria? You said in your original post that you wanted it based on today's date, but in the formula example you provided, you referred to "current week".
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!