Formula Not Working


I have a formula I am using on multiple reports, to pull data into a dashboard. The formula worked on the first two sheets, however it is not working on the third one and I am not able to figure out what I am doing wrong. I have included a screenshot of the formula, a screenshot of a sheet where the formula works, and the data source. We are trying to count the amount of reports received after the end of the month.

Thank you,



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!