IF formula and INDEX(MATCH formula question
![KarenTF](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
I have two sheets: a Program List sheet and a Program Map sheet. On the Program List sheet, there are columns including a severity level (# 1-5), a frequency (# 1-5), and an overall score. On the Program Map, it is set up as a color-coded visual to quickly evaluate the severity vs score. I want to be able to create a formula on the Program Map sheet to pull in the programs from the Program List sheet when specific criteria are met. For instance, if Score is >=25 AND severity is 5, then collect ALL programs that meet these criteria and pull the program names into the desired map area. And then I would proceed to create similar formulae to map the different combinations of score & severity to their appropriate areas on the map.
Can this be done with IF and INDEX(MATCH formulas?
Answers
-
Are you able to provide some manual mock-up example screenshots?
-
I was able to solve this using the JOIN(COLLECT formula on the Program Map sheet!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives