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

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

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

yes that could be a option to write event receivers or a workflow to achieve the same Best Regards, Ashutosh | SharePoint World