Archiving List Items

I have a filtered list setup. New entries to the list will have a sequence number followed by the year. For example: 001-15. For the filtered view, this works fine. When I click the list name and view all list items (unfiltered view), what I have in the list is the following:

001-14

001-15

002-14

002-15

....

Is there a way to archive the 2014 items so they don't show up in the list?

April 24th, 2015 4:58pm

You could modify the All Items view with a Filter where your Column contains -15

Not ideal as you would have to modify it each year. So when 2016 came around you would need to change the filter to -16.

I did try to setup a dynamic filter (but didn't work for me) where the Column contains ="-"&TEXT(NOW(),"yy")

Maybe someone else could provide you with a more dynamic way so you didn't have to modify each year.

Free Windows Admin Tool Kit Click here and download it now
April 24th, 2015 9:22pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics