You need to sign in to do that
Don't have an account?

formula field in LEAD object
I have a requirement to create a formula field as follows:
The formula field should be created on the LEAD object.
The formula field should evaluate the following 5 fields: Email, Phone, Company, Title, and Industry and return 0 if blank and 1 if not blank.
The formula should then add all the values together to return a total value.
Please let me know how to do this?
thanks
meghna
The formula field should be created on the LEAD object.
The formula field should evaluate the following 5 fields: Email, Phone, Company, Title, and Industry and return 0 if blank and 1 if not blank.
The formula should then add all the values together to return a total value.
Please let me know how to do this?
thanks
meghna
All Answers
Greetings to you!
Please try below formula:
I hope it helps you.
Kindly let me know if it helps you and close your query by marking it as solved so that it can help others in the future. It will help to keep this community clean.
Thanks and Regards,
Khan Anas
I am getting an error as
" Error: Formula result is data type (Number), incompatible with expected data type (true or false)."