COUNTIF of CHILDREN with HAS

I'm running into an issue with a formula that I'm trying to write that counts the results of a multi-dropdown column using the CHILDREN hierarchy.

=COUNTIF(CHILDREN([Event Tier]165), HAS(@cell, "Tier 1: Off-Site Event"))

I'm looking for any cells that contain the answer "Tier 1: Off-Site Event" for all the children of [Event Tier]165 which would include cells where there is more then one answer. With the formula above it I'm returning a value of 0 and can't figure it out.

Any help is much appreciated, thank you!

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!