Calculated column – some restrictions

By peter.stilgoe









- You cannot reference a value in a row other than the current row (as opposed to Excel).

- You cannot reference a value in another list or library.
- You cannot reference lookup fields in a formula.

- You cannot reference the ID of a row for a newly inserted row. The ID does not yet exist when the calculation is performed.

Share


About... peter.stilgoe

peter.stilgoeThis author published 482 posts in this site.
Sharepoint, InfoPath, K2, Nintex, Business Process Mapping, Business Intelligence, Automation, ECM, Document Management, Document Imaging, Internet Marketing & Online Business Consultant Email / MSN: pstilgoe@hotmail.com LinkedIn: Pete Stilgoe - Sharepoint Consultant









Share

FacebookTwitterEmailWindows LiveTechnoratiDeliciousDiggStumbleponMyspaceLikedin

No Comments

(Required)
(Required, will not be published)