Formula/pie chart help?

Jen Castillo
Jen Castillo ✭✭✭
edited 09/18/20 in Formulas and Functions

I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper management's viewing.

My first attempt has me using =count functions to count the total number of the pending/fulfilled/cancelled on a different sheet, but I'm not sure how to work the "last seven days" into my formula.

I was thinking it would involve specifying my criteria through vlookup, but I'm inexperienced with anything past basic formulas and am unsure how to continue. If there is a more efficient solution, I am open to that as well!

All help is appreciated, thanks!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!