{"id":489,"date":"2026-05-09T09:00:00","date_gmt":"2026-05-09T03:30:00","guid":{"rendered":"https:\/\/swapnilzambare.com\/blog\/salesforce-formula-fields-field-types\/"},"modified":"2026-10-04T02:18:50","modified_gmt":"2026-10-03T20:48:50","slug":"salesforce-formula-fields-field-types","status":"publish","type":"post","link":"https:\/\/swapnilzambare.com\/blog\/salesforce-formula-fields-field-types\/","title":{"rendered":"Salesforce Formula Fields and Field Types Explained"},"content":{"rendered":"\n

Salesforce Formula Fields let you calculate a value automatically, such as a price with tax or the end date of a course. But before you write formulas, you need to know the field types that hold your data. In our Standard vs Custom Objects guide<\/a>, you built a Course object with a Fee and a Duration field. Now we will add the right fields and teach Salesforce to do the maths for you.<\/p>\n\n\n\n

This post covers the most common field types, how to pick the right one, and how formula fields work. Then you will write five real formulas, step by step. If you have built automation with Salesforce Flow Builder<\/a>, you will see that formulas are an even simpler tool for many small calculations.<\/p>\n\n\n\n

What are Field Types in Salesforce?<\/h2>\n\n\n\n

A field is one piece of information on a record, like a phone number or a price. The field type tells Salesforce what kind of data the field can hold. So a Date field accepts only dates, and a Currency field accepts only money values.<\/p>\n\n\n\n

Think of an online form. A date box shows a calendar, a phone box expects numbers, and a dropdown offers fixed choices. Field types work the same way. They keep data clean because users cannot type the wrong kind of value.<\/p>\n\n\n\n

Field Types to Know Before Salesforce Formula Fields<\/h2>\n\n\n\n

Salesforce offers more than 20 field types. You do not need all of them on day one. The table below lists the ones you will use most often.<\/p>\n\n\n\n

Field type<\/th>What it stores<\/th>Example<\/th><\/tr><\/thead>
Text<\/td>Short text up to 255 characters<\/td>Course code: ENG-101<\/td><\/tr>
Text Area (Long)<\/td>Long text across many lines<\/td>Course description<\/td><\/tr>
Number<\/td>Whole or decimal numbers<\/td>Duration in Weeks: 8<\/td><\/tr>
Currency<\/td>Money values in the org currency<\/td>Fee: 4,999<\/td><\/tr>
Percent<\/td>Percentage values<\/td>Discount: 10%<\/td><\/tr>
Date and Date\/Time<\/td>A day, or a day with a time<\/td>Start Date: 1 June<\/td><\/tr>
Checkbox<\/td>True or false<\/td>Is Online: ticked<\/td><\/tr>
Picklist<\/td>One choice from a fixed list<\/td>Level: Beginner<\/td><\/tr>
Lookup Relationship<\/td>A link to another record<\/td>Teacher on a Course<\/td><\/tr>
Formula<\/td>A value calculated from other fields<\/td>Fee with GST<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

Picklists vs text fields<\/h3>\n\n\n\n

Use a picklist when the answer must come from a fixed list. For example, Level should be Beginner, Intermediate or Advanced. With a text field, users would type “beginer”, “Begin” and “BEGINNER”, and your reports would break.<\/p>\n\n\n\n

Number vs Currency vs Percent<\/h3>\n\n\n\n

All three store numbers, but each one formats differently. Currency adds the currency symbol, and Percent adds the % sign. So pick the type that matches how people read the value.<\/p>\n\n\n\n

Lookup vs Master-Detail<\/h3>\n\n\n\n

Both link two objects. A lookup is a loose link, so the child record can exist on its own. A master-detail is a tight link, so deleting the parent also deletes the children. Our data model guide<\/a> covers relationships in more detail.<\/p>\n\n\n\n

What are Salesforce Formula Fields?<\/h2>\n\n\n\n

Salesforce Formula Fields are read-only fields that calculate their value from other fields, using an expression you write. You write the expression once. Then Salesforce shows the answer on every record, and users cannot edit it.<\/p>\n\n\n\n

A formula field works like a cell in Excel that contains “=B2*1.18”. Whenever B2 changes, the cell updates by itself. Similarly, when a Course fee changes, the “Fee with GST” field updates the next time anyone views the record.<\/p>\n\n\n\n

How Salesforce Formula Fields Work<\/h2>\n\n\n\n

A formula takes input fields, runs an expression and returns a result of a fixed type. The diagram below shows this flow for a Course record.<\/p>\n\n\n\n

\"Salesforce<\/a>
How Salesforce Formula Fields take input fields, run an expression and show a read-only result.<\/figcaption><\/figure>\n\n\n\n

Here are the key rules to remember.<\/p>\n\n\n\n