Multiple IF(AND) References
Hi All,
This might be a simple one but cannot seem to figure out where I'm going wrong. See image below.
So, if my AREA CONCAT column has VALUE 1 in it then I need it to cross reference the first table (bottom right) and run an IF(AND) formula to realize what time slot it's between.
If it's VALUE 2 then it needs to reference the table 2 (bottom right). And there are another 7 more tables like this with 7 different values.
The formula you can see is only for the two tables so far. Is there an easier way to get to this result? Any help on this would help as this formula works for the VALUE 1 but cannot seem to get it working for VALUE 2. I'm wondering if there is a way to infuse an OR function to get to my desired result?
Thanks in advance.
Answers
-
Are you able to create a copy of the sheet and replace the sensitive data with mock data? There should be a way using the INDEX function as the base of the formula but it is hard to tell with so much of your data blocked out.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives