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’’.
Answers

@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
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
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
Categories
Check out the Formula Handbook template!