# I need help creating a Formula

✭✭

Hello,

I need help creating a Formula.

I want to pull the number of cases that has a date for a set time like 04/01/2023- 04/30/2023

The two columns are ‘’Case Number’’ and ‘’Submission Date’’.

• ✭✭✭✭✭✭
edited 03/30/23

@PeterM I would use the COUNTIFS function here:

=COUNTIFS([Case Number]:[Case Number], <> "", [Submission Date]:[Submission Date], <=DATE(2023, 4, 30), [Submission Date]:[Submission Date], >=DATE(2023, 4, 1))

The above would work if the formula is in the same sheet as those columns.

The logic is: Count the rows where the Case Number field is not blank, and where the Submission Date is less than or equal to April 30th 2023, and greater than or equal to April 1st 2023.

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• ✭✭✭✭✭✭

For every line where there is a Submission Date, is there a case number?

This would change how the formula would be set up, if that is not the case.

If my answer helped you, please be sure to mark it as Accepted to help future learners locate the information.

• ✭✭

For every line where there is a Submission Date, is there a case number?

Yes, each submission date has a case number.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!