Complete an action based on matching data in another sheet

I would like to create a formula that will complete an action in one sheet if it see duplicate data in another. For example I have sheet One and sheet Two. If both contain the same name in the [Name] column. I would like to indicate that somehow in sheet #1 either by highlighting a row or using a flag or symbol or even just highlighting the row with a color in some fashion.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!