Need to sum numbers from a metric sheet to a rollup sheet for specific quarters/year

Peggy Parchert
Peggy Parchert ✭✭✭✭✭✭

Is it possible to use a formula to sum the total of a column that meet a criteria? I'm trying to create a rollup sheet (from the data sheet) based on year/quarter. So I'd like to be able to use a formula. I need this to look at the Year and Quarter column as the criteria before it adds the other column together.

I've attached screenshots of my basic rollup sheet. I'm trying to find a way to do this without having to revisit and manually add in items.

Any help would be appreciated.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!