I'm using a calculated column
[DocumentStatus] and versioning to try and do some colour-formatting based on Approval Status. I have Major & Minor versioning turned on.
Since I cannot use Approval Status in a calculated column (and I'd really prefer not to rely on workflows), I have created this formula:
This is supposed to figure out if the document is a major(approved) or minor(not approved). Then I have added some column formatting to change the colour if the text = Approved or Draft.
This works about half of the time. The other half, it just doesn't update. When I approve a document, the version changes to a major version e.g. from 3.4 to 4.0.
[DocumentStatus] field remains as Draft.
If I go into the library settings, open the calculated column and save it (without changing anything) it seems to jumpstart the list again, and the field changes to the appropriate value. But I'd have to do that for every change. Any ideas?? Maybe there's a better formula I can use?