How can we help? 👋

How Do I Use Calculated Fields?

Use calculated fields to use existing fields to produce a numerical result.

Calculated fields serve as invaluable tools for various processes such as lease renewals, move-ins/outs, and invoicing, among others. They empower you to perform calculations based on the values in other fields. In Aptly, creating a calculated field is as simple as adding a new field in Card Settings. Elevate your efficiency and precision with this feature.

In this article, you will learn:

  1. How to add a calculated field
  1. How to use a calculated field in a calculated field

How to Add a Calculated Field

Before adding a calculated field, it’s important to know what you are trying to calculate. Knowing the equation beforehand will help with the setup.

Add a new field by opening up Card Settings in the Board Settings menu on the left.

Notion image
  1. Click on + Add Field.
  1. Select Calculated Field as the Field Type.

Use the image below for more details on setting up a calculated Field.


Using a Nested Calculated Field

You can now use the results of a calculated field within a calculated field.

For example, you want to share the proposed rent increase with your tenant who is up for renewal. However, you include their pet rent and the market rent as a part of the offer.

  1. Create the first calculated field - market rent + pet rent. This is titled Total Rent.
  1. Create a new calculated field. Total Rent x 5%. Let’s title this Proposed Rent Increase.
    1. Notion image
  1. Bonus: Use 2 calculated fields within a new calculated field. Total Rent + Proposed Rent Increase.
    1. Notion image

💡
Do you have a great use-case for calculated fields? Share them in our community!

Related Articles

Did this answer your question?
😞
😐
🤩