Countif by month if due date is next month

Options

Hello Community,

I am having an issue with my formula. I am trying to give my client a SLA timeline on when quotes are due and overdue on a month-to-month basis. Currently my data sheet is counting the quotes per month and if we get the quote in within XX number of days then we get a complete. The issue is if a quote was requested in September but due in October my Data Sheet does not reflect the quote was completed on time in the right month. How can I fix?



Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!