I have this formula in one of my sheets. It was a default formula and it mirrors the rest of the formulas on the page that all work, but it's coming up with #INVALID OPERATION.

=SUM(COUNTIF(Priority:Priority, "High") - (COUNTIFS(Priority:Priority, "High", Status:Status, "Complete")))

The Priority column is a symbol column and they are high medium low so I'm not sure where the issue is. It was originally a column with a formula in it, but it still had the same error. What can I do to fix it?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!