How do a set a formula text field to require a unique value?

Just tested with a different user, different file location, same file and did get the error, as you would expect, with the "fakepath" text.  So, as long as QB doesn't change the way that processes I'm going to call this solved!