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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 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!