Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Filter formula in a doc lib. view

  Asked By: Deandre    Date: Mar 01    Category: Sharepoint    Views: 10352

Does any one know what should be the filter formula to create a view on
doc. lib that shows you documents created in the last 10 days

Following is what I tried but did not work (didn't display even one
document eventhough there were many).

Under Edit Views -> Filter ->
[x] Show items only when the following is true

Show the item when column :
is greater than or equal to




3 Answers Found

Answer #1    Answered By: Blake Marshall     Answered On: Mar 01

What has worked for me is:

1. create  an additional column  with a calculated formula  of
=Created+10, I also choose to format for the returned value of this
formula as date only.
2. Then in the view  create a filter, choose the newly created
column, 'greater than or equal to' and [Today].

Answer #2    Answered By: Dwayne Jensen     Answered On: Mar 01

I tried to create  an additional column  with a calculated formula  of
=Created+10 (Also tried =[Created]=10) and received this error
message: One or more column references are not allowed, because the
columns are defined as a data type that is not supported in formulas.

Any suggestions?

Answer #3    Answered By: Jose Baker     Answered On: Mar 01

I believe System fields are not allowed in formula. I.e. you can only use columns that are available in the list.

Didn't find what you were looking for? Find more on Filter formula in a doc lib. view Or get search suggestion and latest updates.