Bold a row if name matches name from other sheet

Options

Hello,

I have two sheets. Sheet 1 has a list of organizations and I need to check a box if they have received funding from us. Sheet 2 has a list of organizations we have funded in the past. There are over 100 organizations. What would the formula be to say if the organization name on Sheet 1 appears on Sheet 2 check the funded box on Sheet 1.

Please and thank you. Any help is appreciated.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!