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