Countifs Formula Help!

Options

 

The current formula is:

=COUNTIFS(Due:Due, <TODAY(), Disposition:Disposition, <>"Complete") 

I need to count anything that is passed due and not closed, lesson learned or duplicate. I am utilizing a drop down box, too. 

Thoughts?

Branden 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!