How do I get the AR Invoice Age formula to stop aging when invoice has been paid?

Options

I starting to create a AR sheet.

I used the formula =Today()-(Invoice Date Sent)@row - which does show the age. However when the Invoice is paid what formula or rule condition do i use to make it stop aging?


Answers

  • Neil Watson
    Neil Watson ✭✭✭✭✭✭
    Options

    I would introduce 2 columns, a checkbox to indicate payment status, and a date column with the payment date.

    Then amend the invoice age formula as =IF([Payment Status]@row = "0", NETDAYS([Invoice AGE]@row, TODAY()), NETDAYS([Invoice Date Sent]@row, [Date Closed]@row))

    I might have the start and end date for NETDAYS switched around but you get the idea.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!