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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!