COUNTIFS not working where one reference is a column with multiple drop downs...

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, "CASI")

This isn't working... I want a count for if the Priority is Critical (this is in [Column2]$28) and the Platform (from a drop down column) includes CASI. (There may be multiple entries in the drop down column). I know the answer is 1 but it's not returning that number...

HELP!!! Going mad here... 🤔

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!