Formulas are equations that calculate information in a field and return results.
You can add formulas to tables or reports
Formulas can include existing field values to affect or generate content in another field
Formulas are a useful way to deliver information to users, secure and validate data, and drive workflow
What can a formula do?
A formula can do many things, such as:
Calculate an item's total price, including sales tax, on an invoice table
Populate the target completion date of a project
Add color to values or fields in reports to make them stand out
Control what data users see, based on user role and information they've entered