Create formula in summary to calcuate based on date

sholmes
✭✭✭✭✭
Hi, I am trying to use formula on my sheet summary to provide me with the total documents received based on if the date received is before May 1, 2024, of this year. Anyone can help me with that?
Best Answer
-
You would use something along the lines of
=COUNTIFS([Date Received]:[Date Received], @cell< DATE(2024, 05, 01))
Answers
-
You would use something along the lines of
=COUNTIFS([Date Received]:[Date Received], @cell< DATE(2024, 05, 01))
-
@Paul Newcome thanks so much, that seems to be working.
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!