Formula Help: IF Tagging is in the Preperation column, check the box

System

This discussion was created from comments split from: How to checkbox when first and second criteria match in a dropdown list.

Prime George

I have a smaller version of this I am trying to achieve.

I have a multi-dropdown column "Preperation" and Checkbox column "Asset Tag Required".

I am trying this =IF([Preperation]@row = [Asset Tagging]@row, 1, 0)

Goal, if Asset Tagging is in the Preperation column, it will check the box in column Asset Tags Required.

Thank you!

Paul Newcome

Try this:

=IF(HAS(Preperation@row, "Asset Tagging"), 1)