cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

get document version number

Jump to solution

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

Labels: (1)
Tags (1)
0 Kudos
Reply
5 Replies
Workflow Hero

Re: get document version number

Jump to 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:

Minor Version

contains

Minor

Best regards,

Christophe

0 Kudos
Reply
Workflow Hero

Re: get document version number

Jump to solution

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

0 Kudos
Reply
Workflow Hero

Re: get document version number

Jump to solution

I appreciate that you find it so awesome.

So please mark it as Correct answer ;-)

It will also help others

Christophe

Reply
Workflow Hero

Re: get document version number

Jump to solution

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

0 Kudos
Reply
Not applicable

Re: get document version number

Jump to solution

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

0 Kudos
Reply