Formula
Hello, I have a tracker that has columns Customer, Completion Date, and Status.
I would like to count the number of customers where the completion date is between 4/1/2024 and 4/30/2024 and when Status says In Progress. How do I write this out? Thank you in advance for your help!
Answers
-
=countifs( [Completion Date]:[Completion Date], >=DATE(2024,4,1), [Completion Date]:[Completion Date],<=DATE(2024,4,30), Status:Status,"In Progress")
...
-
Thank you. It is showing #UNPARSEABLE
-
This one is working for me, can you double check your date columns if they are actual date in the properties. and the column name matches what we have in the formula.
...
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 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!