Count The Number of Upcoming Deliveries Within a Certain Number Days

Hey there!
I've tried everything.
All I am trying to do is produce a formula that counts the number of deliveries we have in a certain number of days that is not in "lost or cancelled" status. This helps us keep our eye on the prize to ensure we are doing all of our tasks prior to the delivery date so the customer can have a great experience.
Two main columns I'm using are "LOAD IN" and "STATUS"
Logic I'm trying to get to produce a number: If the LOAD IN date is in the next 30 days and is NOT in "lost" or "cancelled" status, count number of entries.
Naturally once I figure out this formula, I can use this to go even further into the future (60, 90, 120 days).
Answers
-
Hey @GeeCil
=COUNTIFS([Load In]:[Load In], ISDATE(@cell), [Load In]:[Load In], @cell>=TODAY(), [Load In]:[Load In], @cell<=TODAY(30), Status:Status, OR(@cell<>"lost", @cell<>"cancelled", @cell<>""))
Does this work for you?
Kelly
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 203 Use Cases
- 515 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 82 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!