Post

1 follower Follow
0
Avatar

Changing manual field to formula

I have a field that is currently manual - one enters a value. I'd like to change this to a formula - but it looks like that is not possible. Can someone confirm? This field is also used elsewhere (alot) is there an easy way to sweep through a find / replace? Anywhere FIELD is used, switch it to NEWFIELD. Thanks.

Christopher Knaus Answered

Please sign in to leave a comment.

4 comments

0
Avatar

Chris, 

Unfortunately, you are not able to change a custom field to add a formula, this has to be configured when the custom field is first created as the Field Type and Formula settings are locked and cannot be changed. you will need to create a new field with formula enabled.

As for the find and replace, this would need to be a workflow rule or Custom Action to allow you to make the change. A workflow rule can be created to basically copy the data from original field to the new custom field. 

Boris Krutiy 0 votes
Comment actions Permalink
0
Avatar

The find and replace would be for the values, but for other formulas, reports and views where the original field is used. Is there an easy way to find this out? Thanks.

Christopher Knaus 0 votes
Comment actions Permalink
0
Avatar

edit - would _not_ be for the values, but for other formulas ... 

Christopher Knaus 0 votes
Comment actions Permalink
0
Avatar

Christopher, unfortunately there is no find and replace for that.

Boris Krutiy 0 votes
Comment actions Permalink