Search: | |||||

| ||||

Home » Forum » Sharepoint | RSS Feeds |

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.

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].

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

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.

Related Topics:

- Convert excel formula to xsl for use in data form web part
- No Formula Bar in Excel Web Part
- Excel Formula in SharePoint Calculated Field/Column
- Link to Specific Excel Workbook in Excel Web Access web part
- Read Excel from sharepoint library using excel service
- Update Excel File using Excel Web Service
- Help with WSS 3.0 formulas
- Using formulas in sharepoint
- How can I build a longer (7>)calculated formula using the =IF function
- xsl formula not working right
- Formulas and calcualtions
- Formulas and calculations
- Filter formula in a doc lib. view
- Column IF formulas only nest seven deep.
- Formulas for Lookup
- Setting the formula of a calculated field using the Object Model
- Filter formula in a doc lib. view
- Formula
- Calculated column formula
- Conditional Logic in Infopath formula controls
- Need help writing a formula for WSS 3.0
- Calculated Column using =LEFT() formula
- 'The formula contains a syntax error or is not supported' Error
- Calculated column - problem with formula
- How to set excel files to open in excel and not in browser?