Display Calls Made Today

I want to do something simple but can't seem to figure it out. In a summary, I want to display the number of "Calls Made" for the current date. In other words, I want to display the number entered in the "Calls Made" column for today. Which function would work best for that?


Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    You'll use SUMIF or COUNTIFS.

    =COUNTIFS([Calls Made]:[Calls Made], [date]:[date:], Today())

    Where [date] is the name of your column. If calls made is a number then you'll want to use =SUMIF( instead.



    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!