INDEX/MATCH with a HAS Function for Multi-Select Column

I am trying to create an INDEX/MATCH where the INDEX is a Checkbox column and the MATCH is a multi-select column. I am not sure how to incorporate the HAS function for the multi-select column. I would like the High Priority flag marked if any/1 or more of the Sites Under Consideration are flagged a High Priority in the separate sheet.

I have gotten the below results with the below formula, but it's not flagging the High Priority? column, instead inputing in True or False. It also doesn't appear to be functioning properly for every row.

=IF(NOT(ISBLANK([Sites Under Consideration]@row)), JOIN(COLLECT({Affiliate Sites Range 2}, {Key ID}, HAS(@cell, [Sites Under Consideration]@row)))

Any assistance is appreciated!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!