Countif by Month in Created column

jmo ✭✭✭✭✭✭

Hi - I'm looking to figure out how to use my Created column to count items that are Main Row "true" and happened in the month of June.

I tried messing with the following formula but came up unparsable - my favorite error :-(

=COUNTIFS([Main row]:[Main row], 1, Created:Created,MONTH(@cell), 0) = 6)

I figure I've left a parenthesis out somewhere or something simple like that.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!