Difference between dates

Options
NLegresley
edited 12/09/19 in Formulas and Functions

Hello

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.

Thanks

 

Dates.PNG

Tags:
«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!