How Many Times an Item was Sent by a Specific Date

Hi,

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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!