I have an existing list with a text field and records in it. Now I want to change that text field into a calculated field to make it concat two other text fields in the list (possibly by changing the schema related to that field thru code behind). I've tried doing..
fieldThree.Type = SPFieldType.Calculated; myList.Update(); SPFieldCalculated calcField = (SPFieldCalculated)fieldThree; calcField.Formula = @"=CONCATENATE([fieldOne],"" "",[fieldTwo])"; calcField.Update();
As it seems.. I can't explicitly convert a text field to a calculated one.