Formula(s) for calculating past due items on a construction punch list.

Jodi Simoneaux
edited 12/09/19 in Formulas and Functions

I'm creating a simple punch list template and would like to add some date calculating functions to it but I'm very unfamiliar with creating date formulas.  I'm attaching a screen shot of this rough template with a sample line already entered.  I would like to create a formula that will tell me how many days past due items added to the list are based on the Date Reported column in relation to today's date.  Anything longer than 5 days would signify it being "past due".  I'm familiar with conditional formatting but I assume I'll need to add a column or 2 to make all of this work.  Can anyone point me in the right direction?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!