Formula to Count with multiple sheet references


So I am understanding COUNTIFS can only reference one sheet per "=COUNTIFS". I have 3 sheets (Appointments, Install, and Completed Install) that I want to pull data from in a count to get a closing percentage for our sales staff.

I am wanting to figure out the time it takes for a customer to go from scheduled appointment to Sold and develop things like closing percentages etc. How would I do based on a reference like Customer# which is on all sheets?

Basically a formula to look at the appointment date and customer number from "appointment sheet" and look at the sold date and customer# from the "install sheet" and "completed sheet"?

This would allow data to pull for things like closing percentage within 30days, 60days, etc...

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!