Count The Number of Upcoming Deliveries Within a Certain Number Days

Options

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).




Tags:

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!