Countifs with dates

Options

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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!