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.
Answers
-
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.
-
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.
-
Try something like this instead:
=IF(COUNTIFS([Sub Record]:[Sub Record], @cell = [Main Record]@row)> 0, "Standard Included", "No Standard")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!