Difference between dates

edited 12/09/19 in Formulas and Functions


I am looking to pull some data from a quote log we have made up. 

What I need to know is what quotes were late submitting by 1-2 days and which were late submitting by 2+ days, so two data points.

Attached is a screenshot of the columns we have. Requested due date is when our customer expected the quote and the date submitted is when we actually sent the quote to them. 

I would like to know how many quotes were overdue for each criteria and possibly a percentage of late quotes for each criteria. 

In the end I am looking to put these metrics on our dashboard.

Any help with appropriate formulas is appreciated.






Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!