+ Start a Discussion
Art SmorodinArt Smorodin 

Formula Value Export

Hi All, 

question regarding Formula field Export. We are currently performing data cleaning in our Org and would like to see the actuall formulas behind the formula filds in order to determin if they are useful or not. What I mean is that for example if I have a formula on the Lead which pulls Owner's Division value I would actually like to see $Owner.Division 

So when I run a report/export/some tool I would see something like:

Lead Owner Division ,   Lead_Owner_Division__c,   Formula (Text) ,   $User.Division

Do you know of any such tool available or if I can actually do it via DataLoader or the Workbench? 

Thanks,
Art.
GarryPGarryP
Hi Art,

For this you need meatada fiel export for the object in which you are interested to get the formulas.
Just goto workbench and export the desired object.using below package.xml
Create a package.xml file and save in local drive

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
    <fullName>test</fullName>
    <types>
        <members>PutAPINameOfYourCustomObjectHere</members>
        <name>CustomObject</name>
    </types>
       <version>33.0</version>
</Package>

1.Got workbench>retrieve
2.Chosse above file.
3.Hit export
4.Open the ZIP archive file
5.Open the .object file in any TEXT editor.
6.Navigate to the FIELD API NAME that have formula.
7.<Formula> tag will give you the required formula.


let me know if this is solution for you. Mark the answer as solved if this helped.

 
GarryPGarryP
Hi,

Was this helpful?