Count entries by month/status

edited 08/04/22 in Formulas and Functions

Hi, I need help with a formula to count entries by the month (Aug) that has a Status of "Scheduled/Published".

I tried this and it gives me "Invalid Data Type"

=COUNTIFS([End Date]:[End Date], MONTH(@cell) = 8, [Status]:[Status], "Scheduled/Published")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!