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)), "-"))

Find more posts tagged with

Accepted answers

All comments

SteyJ

https://community.smartsheet.com/discussion/114101/multiple-sheets-with-if-and-function

@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")

Zachary Hall

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)), "-"))

dharberts

After making the adjustment I get the same response:

#INCORRECT ARGUMENT SET

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.