COUNTIFS Using Mulitple Criteria

I'm trying to get a count of rows where COLUMN 1 displays “Med” or “High” and COLUMN 2 displays a date in the past.


as. well as...


count of rows where COLUMN 1 displays “Med” or “High” and COLUMN 2 displays a yesterday's date.


Any help would be greatly appreciated!  

Best Answers

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!