TransWikia.com

Salesforce Convert a Text to a Formula Field

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)?

One Answer

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

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP