Search for condition across multiple columns if date range is met

sahilhq ✭✭✭✭✭✭


I am trying to insert a formula that looks into my master sheet to find the word "3-MEETS STANDARDS" across 12 columns and when this condition falls between a date range (1st Jul - 15th Jul). I used the formula below and ended up getting a #UNPARSEABLE error. I can't seem to understand where I am going wrong so any help will be greatly appreciated. I have attached a screenshot of my master sheet below for your better understanding.

=COUNTIFS({SELECT ALL 12 COLUMNS}, "3 - MEETS STANDARDS"), {SELECT DATE COLUMN}, AND(@cell >= DATE(2020, 7, 1), @cell <= DATE(2020, 7, 15)))


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!