Search: | |||||

| ||||

Home » Forum » Sharepoint | RSS Feeds |

FWIW, calculated columns can do almost anything that Excel can do. They

are really well documented. The biggest limitation I found is you can

only manipulate data that is in the same listitem.

Often I wanted to use [Today] (and to a lesser extent [Me]) in a

calculated column formula, but it isn't "supported". Fortunately, I've

found if I create a column called Today or Me the formula will pass

validation and use the values in the named column. The Today column does

not have to be a date column, it can be a single text column. This is

awesome for testing.

If you subsequently delete the Today column, the formula will use the

current day in the calculation. Of course, to edit the formula you will

need to recreate the Today column.

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

Related Topics:

- custom calculation fields and colored text in sharepoint document l
- Date calculations
- SharePoint (MOSS) Excel Calculation Services multiple concurrent ses
- Infopath- Exceeded maximum calculations
- Best way to show many multiple calculations
- Starting Excel Calculation Services
- Calculated Column using =LEFT() formula
- No Formula Bar in Excel Web Part
- Excel Formula in SharePoint Calculated Field/Column
- Calculated column - problem with formula
- 'The formula contains a syntax error or is not supported' Error
- Calculated column formula
- Filter formula in a doc lib. view
- Conditional Logic in Infopath formula controls
- Need help writing a formula for WSS 3.0
- xsl formula not working right
- Convert excel formula to xsl for use in data form web part
- Formula
- Help with WSS 3.0 formulas
- Using formulas in sharepoint
- How can I build a longer (7>)calculated formula using the =IF function
- Setting the formula of a calculated field using the Object Model
- Formulas for Lookup
- Filter formula in a doc lib. view
- Column IF formulas only nest seven deep.