Countif formula suddenly stopped working


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. 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!