Here's the formula I added to indicate that there are duplicate equipment assignments for a job. This will notify the users of duplicates equipment assignments for the same job record but not across all job records.
If([Equipment 1]>" ",If([Equipment 1]=[Equipment 2],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png\"</div>";,
[Equipment 1]>" ",If([Equipment 1]=[Equipment 3],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png\"</div>";,
[Equipment 1]>" ",If([Equipment 1]=[Equipment 4],"</div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
[Equipment 1]>" ",If([Equipment 1]=[Equipment 5],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
[Equipment 2]>" ",If([Equipment 2]=[Equipment 3],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
[Equipment 2]>" ",If([Equipment 2]=[Equipment 4],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
[Equipment 2]>" ",If([Equipment 2]=[Equipment 5],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
[Equipment 3]>" ",If([Equipment 3]=[Equipment 4],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
[Equipment 3]>" ",If([Equipment 3]=[Equipment 5],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
[Equipment 4]>" ",If([Equipment 4]=[Equipment 5],"<div><img src=\"
https://images.quickbase.com/si/16/241-triang_yellow.png</div>";,
null)))))))))))
