Summary sheet count when filter on


I am currently using a summary sheet. I have used the following command in one of my fileds

=COUNTIF([% Complete]:[% Complete], <0.99)

But i want to count when one of the columns has a filter. This command still counts all even when i have the filter on / off.

thanks for your help


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!