Past Due Calculation

Hello - I'm trying to build a formula to calculate if a row item is past due based on a value in a due date field. The columns with data are: Approved/Declined Date and Past Due Date. I'm looking for the formula to calculate if Approved/Declined Date is blank and after the Past Due Date to come back with a value of True.

Any help with the above would be greatly appreciated. Thank you!



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!