I would like to be alerted if I enter a duplicate in the “new Item” column,.
You can use the Duplicates and Uniques for this. Here is a demo of how.
If you need any help with the app, you can always reach out at email@example.com
That app is difficult; this should be simple.