Counting formula just based on Status


  • julieg
    julieg ✭✭

    Hello, I"m trying to come up with a formula that will start counting when status changes to "Overdue" and stop counting when status changes to "Complete" (or when date completed is not blank). Is this possible without referencing a date column?

    Thanks for your help,


  • Toufong Vang
    Toufong Vang ✭✭✭✭✭

    You'll need to reference a date if you plan to count the number of days the item has been "Overdue".

    NETDAYS( due_date, TODAY() ) will return the number of days that has elapsed since the item's due date.

    A date is not needed if you simply want to count the number of items that are "Overdue".

    COUNTIF( Status:Status, Status@row="Overdue") will return the number of items that have "Overdue" in the Status column.

  • julieg
    julieg ✭✭


    Thank you so much for responding so quickly. Can you tell me is it possible to modify the formula

    NETDAYS(due_date, TODAY() )

    to also stop counting when completion date is not blank?

    thanks for your help.

  • julieg
    julieg ✭✭

    I'm currently trying this formula, but am receiving INVALID DATA TYPE

    =NETDAYS([Due Date]:[Due Date], TODAY())

    The Due Date Column is a "Date" column. Anything obvious I'm missing? Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!