Calculated fields in SharePoint
Hi,
Is it possible to have user enter value manually for a calculated field (in datasheet view)? Note that the I'm having an if condition in the calculated field and if the condition evaluates to be true then the user entered value must be saved. Else, value
should be calculated based on the formula.Thanks Arut
September 5th, 2011 3:33am
To achieve this you would have to create two columns one as calculated and other to capture user input and then in calculated field put the condition if first column is empty use the calculated value else use the user input column value.
if above suggestion does not suites your requirement then you would have to create a custom field type the way you want it to behave :)Best Regards, Ashutosh | SharePoint World
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 5:49am
Thanks for the response.
However, my requirement is to convert an existing SharePoint field as a calculated field and sometimes the users may enter the value manually. I guess I will have to make use of some SharePoint event receivers.Thanks Arut
September 5th, 2011 7:16am
yes that could be a option to write event receivers or a workflow to achieve the same Best Regards, Ashutosh | SharePoint World
Free Windows Admin Tool Kit Click here and download it now
September 5th, 2011 7:41am