How Many Times an Item was Sent by a Specific Date


I am working on a project where we are trying to identify how many time a report was sent by the last day of the month, after the last day of the month and not sent at all. I am struggling on how to put this together because we would like to be able to display this information on the dashboard. I have included a screen shot of the report I am working on.

For Example we would like to know how many times "Member Files" was sent by the last day of each month, after the last day of each month, or not at all.

Thank you!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    You would need a COUNTIFS.

    This would tell you how many Jan 22 reports were sent prior to Jan 31.

    =COUNTIFS({Source Sheet Jan 22 Column}, @cell<= DATE(2022, 01, 31))

    You would change the DATE portion to be greater than for those that were sent late or blank (double quotes - "") for those that were never sent.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!