get document version number

[melissac]

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

[christopheraucq · Accepted solution]

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

[melissac]

AWESOME!!!!!!

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

[christopheraucq]

I appreciate that you find it so awesome.

So please mark it as Correct answer 😉

It will also help others

Christophe

[melissac]

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

[#6]

Got it for ya. Not sure why it wouldn't work, Melissa Castillo​. Apologies.