You need to sign in to do that
Don't have an account?
Christina Lam 7
Formulas with Different Data Types
Hello! Is it possible to use two data types in a formula? For instance, using a "text" field in a formula for a "number" field.
Thanks!
Thanks!
If you wnated to do it .. you need to use the code
Use:VALUE(text) and replace text with the field or expression you want converted into a number.
Example:Lead Number
VALUE(Lead_Number__c) returns a number for the text value in the auto-number field Lead Number.
https://help.salesforce.com/articleView?id=customize_functions_i_z.htm&type=5