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
user10286user10286 

Formula field gets populated with respect to other fields

Hi All,

Consider there are 3 custom fields A,B,C. A is the formula field, B is the currency field and C is the formula field which gets the output of either A or B based on user inputs. Guide me with the possibilities and formula syntax to generate the output for Field C.Im using PE.

 

 

 

 

 

 

 

 

 

 

Sonam_SFDCSonam_SFDC

By reading the requirement, i understand that you can use the following formula format to accomplish  what you qare trying to do:

IF(logical_test, value_if_true, value_if_false)

 

IF(user_field==XYZ, value from the formula field , value from currency field)

 

What I also understand is that if you want B as the value for a certain user value - the return type of the formula would have to be a currency.