Countif by Month in Created column

Options
jmo
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.

Thanks,

Jeff


Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!