Countifs with dates
I am trying to create a formula that counts the number of open reqs at the end of a month. The fields are in another sheet (call it Sheet) Fields would be req approval date, and offer acceptance date. I have helper fields created, but not using. I have tried, but think the blanks the offer acceptance date are causing me issue. I tried to put a future date, but the formula is not working.
Basically req must be approved by the end of the month, without an acceptance date that is less is greater than the end of the month as i want all reqs open end of month. I tried:
Countifs{Sheet Approval Date}, <DATE(2022,01,31), {Sheet Acceptance Date},
Answers
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 154 Industry Talk
- 502 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 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!