Cannot determine the needed formula

Angela ✭✭
edited 03/23/20 in Formulas and Functions

I am needing to get totals for a column based upon a date. I am tracking daily personnel stats (4 different Columns/options) via form submissions. I need a total daily numbers for each column. Can someone help me please.

Can this be accomplished with sheet summary or via a report. My brain is a bit fried.


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    edited 03/23/20

    Will your calculations be on the same sheet as the source data or a different sheet?

    The basic formula that you would be using would end up looking something like this:

    =SUMIFS([Column To Sum]:[Column To Sum], [Date Column]:[Date Column], @cell = DATE(2020, 03, 20))

    There are numerous variables that can be built in that will allow greater flexibility to cut down on having to edit the actual formula, but that would depend on a number of things surrounding how your counts would be set up and how you intend to use the data.

    EDIT: Corrected typo

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!