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.
Smartsheet Community Champion and Ambassador
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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.3K Get Help
 364 Global Discussions
 200 Industry Talk
 428 Announcements
 4.4K Ideas & Feature Requests
 136 Brandfolder
 127 Just for fun
 128 Community Job Board
 445 Show & Tell
 28 Member Spotlight
 1 SmartStories
 283 Events
 35 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!