CODEWITHSUNDEEP
sharepoint
user1632738
user1632738

Reputation: 41

How does a calculated column work in Sharepoint?

How does acalculated column work in Sharepoint? When a calculated column is added to list, the next moment it'll update the list items. How does it happen?

Upvotes: 4

Views: 30803

Answers (3)

Mihai
Mihai

Reputation: 518

Calculated fields are stored in Database and they are updated when you save an input.

Upvotes: 0

Raheel
Raheel

Reputation: 570

Short Answer: it updates the value when you save an item OR when you change the calculation in the field setting

read this very interesting post. discussion in the comments section is very interesting.

Upvotes: 2

utsikko
utsikko

Reputation: 1545

Calculated columns in SharePoint 2010 are similar to formulas in Excel spread sheet. Their result is attained by writing formula that uses the values of other columns (their names). There are all sorts of formulas to perform calculations as pointed out in the Calculated Field Formulas –msdn page, with example and possible result. You could also check the two links below that show steps of how to achieve a calculated column:

Hopefully, this will make things more clear.

Upvotes: 2

Related Questions