Multiple sheets with If AND function
I'm needing assistance, trying to have the formula for the cell first look in a sheet for a check box, then look back in the original sheet for an AND value, then for the true statement do an Index, Match. I have tries multiple combinations but can figure it out, here is what I currently have:
=IFERROR(IF(AND({Study Device Inventory by Country Range 3} = "True", [# Tablets]@row > 0), INDEX({Study Device Inventory by Country Range 1}, MATCH(Country@row, {Study Device Inventory by Country Range 2}, 0)), "-"))
Answers
-
@dharberts are you getting an error with this formula, or is it not getting the data that you need it to get?
To help with the troubleshoot process, you can try to set a false condition, and a separate IFERROR Function
=IFERROR(IF(AND({Study Device Inventory by Country Range 3} = "True", [# Tablets]@row > 0), INDEX({Study Device Inventory by Country Range 1}, MATCH(Country@row, {Study Device Inventory by Country Range 2}, 0)), "-"), "No Data Found")
Sincerely,
Jacob Stey
-
Hi,
What are you currently getting as a result? I usually use a 1 or 0 for checkbox results, but I know it essentially is just translating it to a True value. I would try changing it though, just to be sure.
- =IFERROR(IF(AND({Study Device Inventory by Country Range 3} = 1, [# Tablets]@row > 0), INDEX({Study Device Inventory by Country Range 1}, MATCH(Country@row, {Study Device Inventory by Country Range 2}, 0)), "-"))
Best,
Zach Hall
Training Delivery Manager / Charter Communications
-
After making the adjustment I get the same response:
#INCORRECT ARGUMENT SET
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!