Can I use the Countif function to count the amount of times one column is greater than another?
For example, in my Smartsheet I have two columns that I would like to compare data. "Sprinkler Head Count (Estimated)" versus "Sprinkler Head Count (Actual)."
I would like to count how many times in my sheet where the Actual head count is greater than the Estimated head count.
Any ideas how we can achieve this?
Thanks in advance!
Help Article Resources
Check out the Formula Handbook template!