I've set up a Calculated field up on a view with the following formula:
At first it's fine. It shows incremental numbers (1001, 1002 etc) but after around two items are added or the view is refreshed it's just showing 800. If I go back into the settings and click on the formula it works again, but only for a short time. Very annoying! How can I get it to work permanently?