get document version number

  • 1 February 2016
  • 4 replies
  • 0 views

Badge +5

I have a user who wants to get an report of all minor versions a document library. I thought that this might be easy. All I need to so was get all "Version" does not end with "0", But I was wrong.  I couldn't do it with a filter. I think I can do it by adding each number to a filter so Version equal 1.1, 1.2 etc. I'm sure that would kinda work. But I'm sure there is an easier way.  Anyone have any suggestions?

Requirement:

List all Documents that are Minor Version does not end in "0"

Document library has version turned on


4 replies

Badge +9

Hi Melissa,

In your Document Library, create a new Calculated column Minor Version with this formula:

=IF(RIGHT(Version,FIND(".",Version))=".0","Major","Minor")

Then create a new view Minor Version with this filter:

Show items only when the following is true:

Minor Version

contains

Minor

Best regards,

Christophe

Badge +5

AWESOME!!!!!! shocked.pnghappy.png

Thank you so much!!! That's Amazing!!

I really appreciate it!  I never thought about that possibility! No you have opened up a whole new World! Yikes mischief.png

Badge +9

I appreciate that you find it so awesome.

So please mark it as Correct answer ;-)

It will also help others

Christophe

Badge +5

I tried to but there seems to be something wrong or I don't have enough permissions. 

Reply