function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Georgia2Georgia2 

Formula Fields to pull data from a related Account based on a look up

Hi

I need help on a couple formulas fields.

 

I have two look up fields (Account Address 1 or Account Address 2) on an Opportunity.  Only one can be completed through a validation rule.

 

Then I need two formula fields, "Ship to Address" and "Shipping Account ID" that will bring over the address and ID from either Account Address 1 or Account Address 2, depending on which look up is complete.

 

What would these two formulas look like??

 

Thanks 

 

Steve :-/Steve :-/

Without have any idea what your custom field names and datatypes are, I think you'd probably be looking for some sort IF formula that basically says 

 

"IF Opportunity.Account Address 1 is blank, then use Opportunity.Account Address 2, otherwise use Opportunity.Account Address 1" 

Message Edited by Stevemo on 12-02-2009 02:02 PM