Need help with an index/match formula

I have two sheets.


A project plan sheet with contacts in the assigned column, then another sheet called Team member that lists the team Member name along with their departments. On the Team member sheet, I want the column to auto populate with either Core or extended depending on if their name displays anywhere in the assigned column on the project. If their name is present, then should display core, otherwise Extended.

My current formula on the team member list displays an invalid data type error: =IF(INDEX({2024 ERM Roadmap - Name}, MATCH([Team Member]@row, {2024 ERM Roadmap - Name}, 0)), "Core", "Extended")

{2024 ERM Roadmap - Name} = is the range on the project plan. Any ideas on how to get it to work?


Project Plan:

Team Member Sheet:


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!