COUNTIFS using current month
I've been doing some searching on here and can't find the solution to my issue.
I have a smartsheet which has four columns. Three of them may have a name (text/number), the fourth is date only. I'm trying to run a formula that detects the total count of name X from columns 1-3, in the current month.
My formula is as follows, but I keep getting "INCORRECT ARGUMENT SET". I'm thinking it's something to do with the fact there's multiple columns to check the name against AND a date field, but I can't work out what I should do about it.
=COUNTIFS([Developer Assigned Date]:[Developer Assigned Date], IF(ISDATE(@cell), MONTH(@cell)) = MONTH(TODAY()), [Developer Assigned]:[OLT Developer Assigned], "David Acord")
Column 1 = Developer Assigned (text/number)
Column 2 = Secondary Developer Assigned (text/number)
Column 3 = OLT Developer Assigned (text/number)
Column 4 = Developer Assigned Date (date)
Help Article Resources
Check out the Formula Handbook template!