#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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!