Calculating Days Remaining and Past Due


Hello everyone,

I am trying to calculate the days remaining and days past due for each row, however, I want it to stop count if the status is closed.

As you can see we have a "Days Remaining/Days Past Due" column and those closed (the grayed out rows) still calculate a number which is what I do not want.

I tried doing it myself but although it counts the days past due, it's not counting the days remaining.

We have various statuses other than open and in-progress. We have a total of 9 different statuses. Just for context.

Please help. Thank you.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!