How do I flag a record where certain criteria are met on other rows?

In my project, I have two record ID numbers – Main Record and Sub record. For every groups of Main Records, there should always be a sub record where the number matches the main record. If a group of main records doesn’t have a sub record with an ID that matches the Main record, I want it flagged.

In the example below Main Record 123456 has a subrecord of 123456 – so everything is great.

Main Record 98765 does not have a Subrecord of 98765 so I need that one marked.

Find more posts tagged with

Accepted answers

All comments

mkoch

In column 4 (Flag Record) add an IF statement to compare the main record to the subrecord. Next add a conditional statement that monitors the flag column being 1. Then hide the flag record column.

AnnaKisting

No, I'm trying to create the goal column.

I need to be able to distinguish between rows Main records that have a sub record that matches the main record and those that do not.

Paul Newcome

Try something like this instead:

=IF(COUNTIFS([Sub Record]:[Sub Record], @cell = [Main Record]@row)> 0, "Standard Included", "No Standard")

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.