Dashboard Reference Data


I am trying to create a Dashboard reference sheet. I want to display to the client the number of quotes they requested and the number of quotes we presented to them on time. Quotes have a time line based on $ value. I don't think I have the right formula to capture the data accurately. What I need is if the quote due date is on or before the quote submitted date the quote is considered "on time" I need to provide the client data that we are providing "on time" requests.

Right now I am just referencing the number of quotes/month by how many we submitted with is not an accurate representation.

Thanks in advance.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!