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
-
Hey @Jaz693
Try this
=IF(COUNTIFS(({2024 ERM Roadmap - Name},[Team Member]@row)>0,"Core", "Extended")
Will this work for you?
Kelly
-
not really. I tried, and I get unparseable now.
-
But I just found the issue. Extra parenthesis. It seems to work now.
-
Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!