#Invalid Data Type
I have a formula in my sheet summary that was working until recently. For some reason the formula is no longer able to count the months or years in the sheet. I also receive the error when I remove the [Current Month]# from the formula and try putting "11".
Does anyone have any recommendations or see anything wrong with the below formulas?
=COUNTIFS([Document Type]:[Document Type], "Net New", ERP:ERP, "NetSuite", Month:Month, [Current Month]#, Year:Year, [Current Year]#)
Current Month Summary Field is: =MONTH(TODAY())
Current Year Summary Field is: =YEAR(TODAY())
Help Article Resources
Check out the Formula Handbook template!