Count Column if cell does not contain


I am working on a sheet summary formula.

The column in question has a formula that will indicate a task is complete based on other criteria. I am trying to calculate the number of rows that are not reading "Complete" in the summary. The formula for that column will return a numerical value for other rows, based on how many days have passed.

=COUNTIF((check:check), <>"complete")

Currently I am getting a return of "0" even thought there are multiple rows that have various numbers in the column.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!