Summary Report Formula

NikkiC
NikkiC ✭
in Formulas and Functions

I have a sheet with the following columns

image.png

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!!!

· Share on FacebookShare on Twitter

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.

    image.png
    image.png


    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!