CountIfs with Date Range on Multi-Select Dropdown


I was hoping to be able to find the answer elsewhere but have had no luck. I was able to build the following formula from other answers but stuck on the last part of the criteria (Warning Items) being in a multi-select drop down. So the formula works but is incorrect in that it does not count cells where there is more than one option selected.

=COUNTIFS({HSE Observations Range 3 Audit Date}, <=StartDate@row, {HSE Observations Range 3 Audit Date End}, >=EndDate@row, {HSE Observations Range 2 Warning Items}, [Observation Item]@row)

Could someone help with the solution? Is this even possible? Any help would be appreciated.


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!