Salesforce Asked by CodeMonger on December 31, 2021
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)?
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)
Answered by barrick on December 31, 2021
Get help from others!
Recent Answers
Recent Questions
© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP