We have a public group that gets notified when a record is created for a custom object. That record goes to the related public group queue and owner is set to the queue. Users will change the owner from the queue to themselves which automatically removes the record from the queue. I need a way to identify the records that have been in the queue longer than 7 days so an email can be sent to management for follow up.
I'm comfortable with the email portion inside flow, I just can't for the life of me figure out how to write a condition/formula to identify those records.
Thanks @Davis Johnson, that helped for sure. I think I'm going to create a simple flow that checks a hidden box when the owner is changed. Then I can reference that checked box in a formula to sort out records already assigned.
