Formula referencing another sheet

edited 06/15/22 in Formulas and Functions

Hi all - new to formulas. This is what I'm trying to do...

Sheet A: has list of all members

Sheet B: has requests from anyone, not just members.

We want to have B look at A and if a request is from a member, it states on Sheet B that yes this person is a member so they should get the discount for their request.

So I need it to look to see if the person's name is on Sheet A and return back saying Yes or No.

Is this an "If" formula? Index?

Any help is appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!