IF/AND Function Across Different Sheets

Beckstrm

Hello,

I am trying to get information from one sheet to populate another sheet.

The formula I am trying to use is: =IF(AND({Equipment} = "MIGU-1", {Status} = "Open"), "Deployed", "Available")

I get an #Invalid Operation error.

On sheet 1 is the data I'm trying to separate out...

using the "Type of Equipment" column and the "Mission Status" column and placing the result in sheet 2...

Suggestions?

Thanks,

Mike B.

Find more posts tagged with

Formulas

Accepted answers

Kelly Moore

Hello @Beckstrm

Querying IFs across sheets require a different approach and some different functions.

Try this

=IF(COUNTIFS({Equipment}, "MIGU-1", {Status},"Open")>0, "Deployed", "Available")

This says if COUNTIFS (using your criteria) is greater than zero, it must have found something so return the true result, otherwise return the false result.

Kelly

All comments

Kelly Moore

Hello @Beckstrm

Querying IFs across sheets require a different approach and some different functions.

Try this

=IF(COUNTIFS({Equipment}, "MIGU-1", {Status},"Open")>0, "Deployed", "Available")

This says if COUNTIFS (using your criteria) is greater than zero, it must have found something so return the true result, otherwise return the false result.

Kelly

Beckstrm

THANK YOU!!!

It works!

Mike

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.