Summary Report Formula

I have a sheet with the following columns

I need to create a quarterly dashboard finding the total of each channel by quarter. I am currently doing this formula in summaries:

=COUNTIFS(Quarter:Quarter, "Qtr 1", Channel:Channel, "Search")

My question is, is there a better way to get values? There are a lot of channels and I havent even made a dent in q1. PLEASE HELP!!!

Answers

  • Razetto
    Razetto ✭✭✭✭✭✭

    @NikkiC I can think of 2 ways right now on how to set a template (Sheet) for the calculations, see below; it all depends on how you need it. Use the absolute reference ($) in the functions to make it easier when dragging (or copy/paste) the formula.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!