Some limitations of calculated columns:
- You cannot reference a value in a row other than the current row (as opposed to Excel for example).
- You cannot reference a value in another list or library.- You cannot reference lookup fields in a formula (see earlier blog)- You cannot reference the ID of a row for a newly inserted row. The ID does not yet exist when the calculation is performed.
No comments:
Post a Comment