Days past due

Options

I am trying to track days past due in a cell until a date is entered in another cell. I don't have issues with the formula tracking the days but I want the formula to zero out when the date is entered in another cell.

days past due would = 0 if the invoice status is "Paid"

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!