# Gaining Efficiency through Formulas

## Formulas are a powerful tool to help automate and configure applications to be most effective. (II07)

### About this course

Gaining Efficiency through Formulas

As your application grows, so will the need for efficiency in how you use and exploit your data.  Formulas are a powerful tool to help automate and configure applications to be most effective.  This course covers how and when to use formulas to combine the contents of fields to create new data and efficiency through automation.

In this course, learn to:

• Describe the benefits of using formulas in Quick Base
• Use formulas
• Troubleshoot formulas

Course ID: II07

### Curriculum61 min

• Getting Started with Formulas
• Introduction to Gaining Efficiency Through Formulas 8 min
• Formula Resources 2 min
• Formula Examples
• Formula Example: Calculate Invoice Fields 5 min
• Formula Example: Concatenate Text 2 min
• Formula Example: Mask Text Characters 3 min
• Formula Example: If and Case 19 min
• Formula Example: Calculate Anniversary Date 2 min
• Formula Examples: Calculate Age and Tenure 5 min
• Formula Example: Row Colorization 4 min
• Troubleshooting Formulas
• Troubleshoot Your Formula 7 min
• What Do You Think?
• Please Rate This Course - II07: Gaining Efficiency through Formulas

Gaining Efficiency through Formulas

As your application grows, so will the need for efficiency in how you use and exploit your data.  Formulas are a powerful tool to help automate and configure applications to be most effective.  This course covers how and when to use formulas to combine the contents of fields to create new data and efficiency through automation.

In this course, learn to:

• Describe the benefits of using formulas in Quick Base
• Use formulas
• Troubleshoot formulas

Course ID: II07

• Getting Started with Formulas
• Introduction to Gaining Efficiency Through Formulas 8 min
• Formula Resources 2 min
• Formula Examples
• Formula Example: Calculate Invoice Fields 5 min
• Formula Example: Concatenate Text 2 min
• Formula Example: Mask Text Characters 3 min
• Formula Example: If and Case 19 min
• Formula Example: Calculate Anniversary Date 2 min
• Formula Examples: Calculate Age and Tenure 5 min
• Formula Example: Row Colorization 4 min
• Troubleshooting Formulas
• Troubleshoot Your Formula 7 min
• What Do You Think?
• Please Rate This Course - II07: Gaining Efficiency through Formulas