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")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!