Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Excel Formulas

  Asked By: Denny    Date: Feb 07    Category: Sharepoint    Views: 1548

Do view filter formulas take pretty much any kind of Excel formula?

I'm trying to figure out how to get a view to show items based on them
having an ItemDate value in the next ten days.

Something like:

ItemDate < Today + 10


ItemDate > Today - 1

Will something like this work? I'm guessing there's alot of you guys
that know Excel formulas alot better than me.



3 Answers Found

Answer #1    Answered By: Irvin Foley     Answered On: Feb 07

The best solution to creating an ItemDate in the next x days  is to
create a custom column that generates a calculated date that you can use
in a filter  compared to [Today].

For instance, let's say that I wanted to only show  the items  that have
been modified in the last ten days. I would add a calculated date column
called something like ModifiedPlusTenDays to the list with a formula
like: [Modified]+10

Then you can setup a filter on any listview where ModifiedPlusTenDays is
less than [Today].

Answer #2    Answered By: Deonte Stein     Answered On: Feb 07

what would be super nifty though is if i could set an alert based  on a category. is that easily possible?

Answer #3    Answered By: Stephon Valentine     Answered On: Feb 07

the only kind  of filtered alters are on the Issues list and
then only for the Assigned To column. Whenever an issue list item is
added/changed, you can optionally setup the list to email the Assigned
To person.

Didn't find what you were looking for? Find more on Excel Formulas Or get search suggestion and latest updates.