I have a large sales force and we track everything by customers email address. Trying to prevent users from saving duplicate records that have been worked in the last 90 days by other users. I've tried several of the formulas posted here, but none work. My issue seems to be that users can only see records assigned to their role. But I want to prevent the same sales person from saving records that are already being worked by another sales person in the last 90 days. So need a formula that will check the whole data base, and alert that user the record already exist.