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
Prasanth Reddy MPrasanth Reddy M 

Can we have a formula field , which will be updated based on two other fields ?

In Leads Page, I want to have  a Sales Score Text field (formula field ), which needs to be updated by first checking the campaign field is empty or not and has to update the Sales Score field based on other Campaign Score field (Number field).

Is this is possible with Formula fields, if so how ...

Please clarrify..
Best Answer chosen by Prasanth Reddy M
Satish_SFDCSatish_SFDC
Yes you can use an if statement in a formula field.

IF(ISBLANK(Campaign_Field_Name),Campaign_Score_Field_And_Any_Arithmetic_Here,"NA")

Regards,
Satish Kumar

All Answers

Satish_SFDCSatish_SFDC
Yes you can use an if statement in a formula field.

IF(ISBLANK(Campaign_Field_Name),Campaign_Score_Field_And_Any_Arithmetic_Here,"NA")

Regards,
Satish Kumar
This was selected as the best answer
Yoganand GadekarYoganand Gadekar
if all the fields required for calculation are on lead then it is possible