Need help with Countif date formula

I have a date column, and I want to count the number of "Good Rolls" for that specific date.

I managed to get Shift LBS Produced for the 24th and Total Rolls.

The number 81 in good rolls column reflects the total for all date. How do I get a result for just the 24th, 25th etc.

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    What did you to do get the other two that are working for you?

  • SSFeatures
    SSFeatures ✭✭✭✭✭

    Hi Mike, are "Good Rolls" coming from another sheet? Does that sheet have multiple rows for a specific date?

    You'll most likely want to use SUM and COLLECT, but it's hard to know for sure without knowing more about where good rolls is coming from.

    You'll probably want something like this:

    =SUM(COLLECT({Good Rolls Range}, {Date Range}, @cell = [Date]@row))
    

    Can you add a screenshot of your other sheet? Then I can help make sure that the Cross-References that I put in the formula are accurate for your other sheet.

    Best!

    SSFeatures - The browser extension that adds more features into SmartSheet.

    • Automatic sorting, sorting with filters, saving sort settings
    • Spell checking
    • Report PDF generator that supports grouped and summarized reports

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!