1

I want to change a Text Field to a picklist. I know how to actually change the field type however I have several Formula fields that reference the Text Field so when I try and change the field type, it states that I cannot because they are referenced in a Formula.

You cannot deactivate Formula Fields, I cannot change the Formula field to TEXT(Field__c) until the field is a picklist. How can this be handles is the only way to change the formula to a place holder reference then change the field type to a picklist and change the formula fields to reflect TEXT(Field__c)?

Improve this question
4
  • 3
    How about changing the field reference in the formulae to a string literal of the API name - 'Field__c' rather than Field__c - updating the field type, then adjusting the formulae to TEXT(Field__c)?
    – dyson
    Jul 24, 2020 at 22:28
  • Are you familiar with sfdx or the metadata api? You may be able to download the metadata for the necessary fields, make the changes directly in the xml files and then deploy all fields in one go.
    – adriancg
    Jul 24, 2020 at 22:57
  • 1
    @barrick You should add that as an answer
    – Nick C
    Jul 25, 2020 at 0:00
  • Thanks guys, that's kinda what I ended up doing was creating it as 'field'. Just kinda of a pain but I suppose that would happen in any IDE
    – CodeMonger
    Jul 25, 2020 at 23:11

1 Answer 1

Reset to default
1

Change the field reference in the formulae to a string literal of the API name - 'Field__c' rather than Field__c - updating the field type, then adjust the formulae to TEXT(Field__c)

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .