How to use IF formula with DATA from another sheet

Hello, fantastic community; I want to build a formula that If a cell = XXX, then it will work with me the value of another sheet- can you guys help me? formula

=if(coachname=coachname in another sheet, cell b of that other sheet info is true)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!