Trying to use COUNTIF with criteria from 2 columns.

I have 2 columns I want to pull from, one is Issue Status should equal 'Open', and second is Target Date which I only want to count if it's in the past. Below is the formula I have, but I'm getting an error.

=COUNTIFS([ERM Target Date]:[ERM Target Date], @cell < TODAY(),[Issue Status]:[Issue Status], [Issue Status]2))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!