Incorrect Argument Set for MATCH, IF, AND formula

Hi there,

I feel like I'm close to a solution. I'm working in a symbol column that I would like to automate to turn either Gray or Green.

I would like to match a row across different sheets, if specific columns are blank on the other sheet for the match row, I'd like to return a gray symbol, if any one of them is not blank, I'd like to return a green symbol.

I've tried to nest an IF/AND statement into a MATCH operation. I'm getting 'incorrect argument set'.

=MATCH([NCT Number]@row, {NCT}, (IF(AND({Update Expected} = "", {Corrections Expected} = "", {Results Expected} = "", {All Results Expected} = ""), "Gray", "Green")), 0)

Is this figure-out-able?

Thank you!

Meredith

Find more posts tagged with

Formulas

logic

Accepted answers

DKazatsky2

Hi @Meredith Rhodes,

Give this a try.

=IF(COUNTIFS({NCT}, =[NCT Number]@row, {Update Expected}, ="", {Corrections Expected}, ="", {Results Expected}, ="", {All Results Expected}, ="") > 0, "Gray", "Green")

Hope that helps,

Dave

All comments

DKazatsky2

Hi @Meredith Rhodes,

Give this a try.

=IF(COUNTIFS({NCT}, =[NCT Number]@row, {Update Expected}, ="", {Corrections Expected}, ="", {Results Expected}, ="", {All Results Expected}, ="") > 0, "Gray", "Green")

Hope that helps,

Dave

Meredith Rhodes

Yes! Thank you @DKazatsky2! Success!

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.