Countif formula suddenly stopped working

Jawanza Hadley

Hello, 

I have a formula that has been working perfectly for the past 8 months. It's a very simple count if formula. Below is the formula that I copied directly from smartsheets. Anyone have an idea why this all of a sudden returned an "invalid opeartion" error when it has been working before? 

=COUNTIF(Status:Status, "Red")

The same problem has occurred with a countifs error: 

=COUNTIFS(Status:Status, "Red", [Must Have]:[Must Have], "Yes")

Any ideas or suggestions would be helpful. Again, both of these formulas were working perfectly. 

Paul Newcome

Has anything changed other than adding new rows? Any column name changes, column(s) added or deleted, etc.?