How can I use an IF statement with INDEX/DISTINCT?

Hello,

I am trying to pull distinct information from a different sheet if a box is checked.

Here is my formula to pull in the distinct information:

=IFERROR(INDEX(DISTINCT({Source Sheet Column_Name}), ID@row), "")

Now, I have a checkbox column called AX S2 and I just want the information from the rows that are checked in this column.

So, if the AX S2 column is checked, then pull the information.

Thank you!

Find more posts tagged with

Formulas

Accepted answers

All comments

Marcodip

Did you try building a report based on this sheet and then filtering by "AS S2 is checked"?

Desiree500

@Marcodip

Yes I did and it's not what I expected in terms of format. I found a workaround for this, thank you for your help!

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.