INDEX/COLLECT Formula Help

Hello All,

I am hoping this community can help me figure a particular scenario out:

I have 2 Sheets: Sheet A, Sheet B

I want to look at Sheet B:

Find a unique identifier in Column A (this is also the same unique identifier in Sheet A, Column A), then look at column C to see if it's blank.

If it's not blank, I want a checkbox to be checked in Column D in Sheet A.

I know that I need to use INDEX(COLLECT, but I can't seem to choose the correct range, criterion, range, etc.

Any help would be greatly appreciated!!

Find more posts tagged with

Formulas

Accepted answers

All comments

heyjay

=IF(INDEX({Sht.A-Col.C}, MATCH(ID@row, {Sht.A-Col.A})) = "", 1, 0)

Sheet A -

Sheet B -

jl.furstenberg

Hello heyjay,

Thank you for the quick response! It's close, but not quite what I am looking for:

I want the box to be checked if Sheet A Col. C is NOT blank. How would I incorporate that into your formula above?

heyjay

https://community.smartsheet.com/discussion/comment/444719#Comment_444719

Oh, replace = with <> .

Not Equals to Blank. You can also use IF(NOT(ISBLANK…

=IF(INDEX({Sht.A-Col.C}, MATCH(ID@row, {Sht.A-Col.A})) <> "", 1, 0)

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.