Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

Can I combine two COUNTIFS formulas if there is a Date Range?

I use this formula to identify how many Requests a certain Division entered.

=COUNTIFS({Divisions}, [Request Entered by]@row, {Request Type}, "Template Request")

I want to combine it with this formula to identify how many times a month, does that certain division enter specific request.

=COUNTIFS({Request Entered Date}, <=(DATE(2023, 8, 31)), {Request Entered Date}, >=(DATE(2023, 8, 1)))

If there is another way to go about this, would love to hear it. 😀

Thank you,

Hector Arriaran

Customer Care Specialist

Vanderbilt University Medical Center

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions