Stuck on a formula for a multi-drop down


Hi everyone,

I'm using sheet summary to count various formulas for me and I'm stuck on the below. I need to count all rows that have "Strategy" in the Channel column, whether it's the only entry or one of several.

I've tried variations using HAS or CONTAINS but it still doesn't work.

=COUNTIFS(Archived:Archived, IFERROR(YEAR(@cell), 0) = 2023, Stage:Stage, "Complete", Channels:Channels, "Strategy")

Thanks in advance!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!