When do Sharepoint Calculated Columns actually get calculated?

1
votes

I'm having some problems with calculated columns in Sharepoint 2007. They don't appear to be working as expected.

So, I decided to try something simple. Basically, I wanted to check a Content Type.

The formula is:
=IF([Content Type]="PictureView","IsPicture","NotPicture")

This column is added to the Default View of the Document Library. I would expect the column to be filled with either "IsPicture" or "NotPicture" (without the quotes).

However, only a few sporadic cells are populated for that calculated column.

Can anyone shed some insight as why this is happening? Why doesn't it populate the entire column?

Thanks!
Dave

1
sharepoint

1 Answers

2
votes

Calculated columns store their value in the database and are set when the record is updated - they won't be set for records that were already there when the calculated field was added.

Computed fields are calculated on view, but they aren't available through the browser interface.